各位兄弟姐妹!我有一个问题卡住了,大家帮帮我吧!
我在用VB+access做MIS系统,现在需要把Access中一个查询结果导出到DBF,现在总是出现这样的一个错误,我把'" & CStr(rs("Itemname")) & "'换成:'1'就可以通过,或者换成跟前面字段值一样也可以!请大家帮帮忙,多出出主意,帮顶者有分!
Private Sub OutDbf()
'On Error Resume Next
Screen.MousePointer = vbHourglass
Dim dbfPath As String
Dim dbfConn As New ADODB.Connection
dbfPath = Text1
With dbfConn
.ConnectionString = "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=" & dbfPath
.CommandTimeout = 0
.Open
End With
Set rs = Conn.Execute(Me.Tag)
Do While Not rs.EOF
dbfConn.Execute "insert into " & dbfPath & "(USERNAME,ITEMNAME,PRONAME,DJ,NUMS,CURRPAGE,CURRROW,DTIME) values('" & CStr(rs("Username")) & "','" & CStr(rs("Itemname")) & "','" & CStr(rs("Projectname")) & "','" & rs("DJ") & "','" & rs("Nums") & "','" & rs("CurrPage") & "','" & rs("CurrRow") & "','" & rs("Dtime") & "')"
rs.MoveNext
Loop
Set rs = Nothing
dbfConn.Close
Screen.MousePointer = 0
End Sub
command contains unrecognized phrase/keyword