我要导出数据库,错误提示如下:
select 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确
Dim cn As New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + App.Path
+ "\test.mdb"
cn.Execute "select into ddd from OPENROWSET
(SQLOLEDB,northwind;sa;neary,customers99)"
OPENROWSET 只能用于 SQL Server!!!