从Excel到Access中,可以通过
adoconnection连access.
ADOConnection.Execute('select * into txzm2 from [excel 8.0;database=e:\xzm.xls].[sheet1$]');下面是从SQL Server到Access中,可以通过
adoconnection连access.
ADOConnection.Execute('Select * Into txzm from 物料 in [odbc] [ODBC;Driver=SQL Server;UID=;PWD=;Server=Server;DataBase=进销存;]');//从Access到SQL Server,不能通过
ADOConnection连SQL Server.
ADOConnection.Execute ('SELECT * into txzm FROM [d:\刷卡系统\database\djbjxt.mdb;pwd=xmzw].ttemp');
错误信息:对象名d:\刷卡系统\database\djbjxt.mdb;pwd=xmzw].ttemp无效;
用from ttemp in [ODBC] [ODBC;Driver={Microsoft Access Driver (*.mdb)};PWD=xmzw;DBQ=d:\刷卡系统\djbjxt.mdb;]也不行
错误提示:在关键字'in'附近有语法错误Access到Excel,不能通过
ADOConnection连Execel;
ADOConnection.Execute('select * into txzm from ttemp in [ODBC] [ODBC;Driver={Microsoft Access Driver (*.mdb)};PWD=xmzw;DBQ=d:\刷卡系统\djbjxt.mdb;]');
错误信息:不能使用ODBC来输入,输出或将一个外部Microsoft Jet或ISAM数据库链接到你的数据库.如何才能解决以上出现的问题?
adoconnection连access.
ADOConnection.Execute('select * into txzm2 from [excel 8.0;database=e:\xzm.xls].[sheet1$]');下面是从SQL Server到Access中,可以通过
adoconnection连access.
ADOConnection.Execute('Select * Into txzm from 物料 in [odbc] [ODBC;Driver=SQL Server;UID=;PWD=;Server=Server;DataBase=进销存;]');//从Access到SQL Server,不能通过
ADOConnection连SQL Server.
ADOConnection.Execute ('SELECT * into txzm FROM [d:\刷卡系统\database\djbjxt.mdb;pwd=xmzw].ttemp');
错误信息:对象名d:\刷卡系统\database\djbjxt.mdb;pwd=xmzw].ttemp无效;
用from ttemp in [ODBC] [ODBC;Driver={Microsoft Access Driver (*.mdb)};PWD=xmzw;DBQ=d:\刷卡系统\djbjxt.mdb;]也不行
错误提示:在关键字'in'附近有语法错误Access到Excel,不能通过
ADOConnection连Execel;
ADOConnection.Execute('select * into txzm from ttemp in [ODBC] [ODBC;Driver={Microsoft Access Driver (*.mdb)};PWD=xmzw;DBQ=d:\刷卡系统\djbjxt.mdb;]');
错误信息:不能使用ODBC来输入,输出或将一个外部Microsoft Jet或ISAM数据库链接到你的数据库.如何才能解决以上出现的问题?
2:
http://expert.csdn.net/Expert/topic/2341/2341997.xml?temp=.2739221
SQL语句导入导出大全
3:
http://expert.csdn.net/Expert/topic/2461/2461899.xml?temp=.39555
交流--导入/导出Excel