各位好,access导入到sqlserver,出现问题,帮忙解决一下吧!
代码如下:
SELECT * INTO app_dept_t FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source=C:\Program Files\bjsd\gxfco.dbx;User ID=Admin;Password=8888888') app_dept_t
提示说app_dept_t附近有语法错误,请帮忙解决解决吧!谢谢!
代码如下:
SELECT * INTO app_dept_t FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source=C:\Program Files\bjsd\gxfco.dbx;User ID=Admin;Password=8888888') app_dept_t
提示说app_dept_t附近有语法错误,请帮忙解决解决吧!谢谢!
select *
into t
from opendatasource('microsoft.jet.oledb.4.0','data source="文件路径";user id=admin;password=;')...表名