VB与dbf的连接问题
我想在dbf中用脚本导入一个excel表,然后生成一个.dbf文件
以前没有用过vfp,请XSJM帮忙
代码如下:
Dim consql1 As New Connection
Dim rs1 As New ADODB.Recordset
Dim str1 As String
With consql1
.ConnectionString = "ROVIDER=MSDASQL;DRIVER={Microsoft Visual Foxpro Driver};SourceDB=D:\RongHua project\Database\DBF\TaxSystem;SourceType=DBF"
.CursorLocation = adUseClient
.ConnectionTimeout = 180
End With
str1 = "import from " & """" & StrDes & StrID & ".xls""" & " type XL8 Select " & """" & "Report" & """"
If rs1.State = 1 Then rs1.Close
rs1.Open str1, consql1, adOpenStatic, adLockReadOnly
rs1.Close
调试的str1的值为 import from "D:\RongHua project\Output\111111111111111.xls" type XL8 Select "Report"
可到数据库中运行这个脚本时出如下错误:
连接无法用于执行此操作。在此上下文中它可能已被关闭或无效