参对上下两例:
下例,excel导出到access正常Private Sub adoconnect()
Dim adocon As new ADODB.Connection
Dim adocmd As new ADODB.Command EXLdsnless = "provider=msdasql;driver={MICROSOFT EXCEL DRIVER (*.XLS)};dbq=c:\SOURCE.XLS"
adocon.Open EXLdsnless
cmdstring = "select * into [;database=c:\dest.mdb].[t1] from [source$]" '运行正常
adocmd.ActiveConnection = adocon
adocmd.CommandType = adCmdText
adocmd.CommandText = cmdstring
adocmd.Execute
Set adocmd = Nothing
adocon.Close
Set adocon = Nothing
End Sub为什么 excel 导出至 access 正常
而 text 导出至 access 有误?
是不是text的 ODBC驱动不支持 select into 语句?
下例,excel导出到access正常Private Sub adoconnect()
Dim adocon As new ADODB.Connection
Dim adocmd As new ADODB.Command EXLdsnless = "provider=msdasql;driver={MICROSOFT EXCEL DRIVER (*.XLS)};dbq=c:\SOURCE.XLS"
adocon.Open EXLdsnless
cmdstring = "select * into [;database=c:\dest.mdb].[t1] from [source$]" '运行正常
adocmd.ActiveConnection = adocon
adocmd.CommandType = adCmdText
adocmd.CommandText = cmdstring
adocmd.Execute
Set adocmd = Nothing
adocon.Close
Set adocon = Nothing
End Sub为什么 excel 导出至 access 正常
而 text 导出至 access 有误?
是不是text的 ODBC驱动不支持 select into 语句?
该命令查询为:
cmdstring="select * into desti.txt from source.txt"
又可以运行正常。怪怪怪!!!
text->access
怪怪怪!!!
但是我做过类似的处理,用
DAO同时打开两个结果集对倒,没有问题。
所有的JET IISAM驱动我都试过。
adorst_destination.AddNew
adorst_destination(0)=adorstsource(0)
adorst_destination(1)=adorstsource(1)
......
adorst_destination.Update是吗?
个人意见也是觉得在这些单机数据库中导数据似乎用DAO效率更高。
如有SQL SELECT INTO解决方案者,还有高分奉上。
用select into 语句真的不能将数据从text中导入access吗?
楼上兄台见谅
请检查select * into [;database=c:\dest.mdb].[t1] from source.txt语句