我是用DSN连接的DBF文件:
Cnn.Open "DSN=DSN名;"
Cnn.CursorLocation = adUseClient
Cnn.Execute "select * into 新表 from 表1"提示第三句语法错误
可是当我用DAO操作DBF时也可以呀?
Cnn.Open "DSN=DSN名;"
Cnn.CursorLocation = adUseClient
Cnn.Execute "select * into 新表 from 表1"提示第三句语法错误
可是当我用DAO操作DBF时也可以呀?
dim cnstr as string,sqlstr as string
cnstr="driver={microsoft visual foxpro driver};"&_
"sourcetype=dbf;"&_
"sourcedb=;"& app.path &"\data;"&_
"execlusive=no"
adodc1.connectionstring=cnstr
sqlstr="select * from XXX.dbf",cn,adopenkeyset,sdlockbatchoptiomistic
adodc1.recordsource=sqlstr
adodc1.refresh
set datagrid1.datasource=adodc1
datagrid1.refresh
用新表的那个语句我也用过,同样的错误
另外我用的是ODBC连接DSN