Dim cn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
Dim sql1, hxcq As String
cn1.ConnectionString = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceType=DBF;DBQ=d:\dy;SourceType=DBF"
cn1.Open
cn1.Execute ("select zjzh,sum(jsxf) as jsxf into table 1 from lscj group by zjzh")
测试运行不报错,但是1.dbf就是生成不出来.谁能帮忙看看问题出来那里
Dim rs1 As New ADODB.Recordset
Dim sql1, hxcq As String
cn1.ConnectionString = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceType=DBF;DBQ=d:\dy;SourceType=DBF"
cn1.Open
cn1.Execute ("select zjzh,sum(jsxf) as jsxf into table 1 from lscj group by zjzh")
测试运行不报错,但是1.dbf就是生成不出来.谁能帮忙看看问题出来那里
是SQL Server 的语法,并不通用,不是标准语法,比如在Oracle中就不能这样用!
在dbf里面是有的,
表名 1 是否合法