我的程序如下: Dim cnn1 As ADODB.Connection Dim strcon, mystr As String strcon = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=cur" Set cnn1 = New ADODB.Connection cnn1.Open strcon mystr = "insert into a10(aa,bb) select date_time,s132ma_ana from 1001" cnn1.Execute mystr,这是我的程序,报错说语法错误(其中1001和a10都为vfp自由表)
Dim cnn1 As ADODB.Connection
Dim strcon, mystr As String
strcon = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=cur"
Set cnn1 = New ADODB.Connection
cnn1.Open strcon
mystr = "insert into a10(aa,bb) select date_time,s132ma_ana from 1001"
cnn1.Execute mystr,这是我的程序,报错说语法错误(其中1001和a10都为vfp自由表)