程序中实现:连接access文件,用jet SQL来导先用Jet4.0连接access文件 用adoQuery执行: insert into [ODBC][ODBC;Driver=Sql Server;UID=sa;PWD=填入密码;Server=服务器ip;DataBase=目标数据库;].[目标表] select * from access表SELECT * INTO [ODBC;Driver=Sql Server;UID=sa;PWD=填入密码;Server=服务器ip;DataBase=目标数据库;].[目标表] FROM access表
用adoQuery执行:
insert into [ODBC][ODBC;Driver=Sql Server;UID=sa;PWD=填入密码;Server=服务器ip;DataBase=目标数据库;].[目标表] select * from access表SELECT * INTO [ODBC;Driver=Sql Server;UID=sa;PWD=填入密码;Server=服务器ip;DataBase=目标数据库;].[目标表] FROM access表