从SQL Server导出时,用以下语句:
ADOConnection.Execute('Select * Into [Text;Database=c:/temp].aaaa.txt From aaaa');
报错:[c:/temp].aaaa.txt 数据库不存在;
连接SQL Server的ADOConnection使用Microsoft OLE DB Provider for SQL Server;
改用Access导出Text,ADOConnection用Jet 4.0,可以成功。什么原因?
我都说了要举一反三的,可是还是有人问类似的问题,算了,再贴两个例子
c:/temp/aaa.dbf to Access,
ADOConnection 指向Access
语句是 select * into bbb from aaa in 'c:/temp' 'dbase 5.0;'
sql server导出到access
ADOConnection 指向Access
SELECT * into table FROM Tab1 IN [ODBC]
[ODBC;Driver=SQL Server;UID=sa;PWD=;Server=127.0.0.1;DataBase=Demo;]