我的语句如下面: INSERT INTO opendatasource("Microsoft.Jet.OLEDB.4.0","f:\新建文件夹\11111\db.mdb";password=) 导入(MName,PasteBoardWidth,Quantity,TotalLength) SELECT MName,PasteBoardWidth,Quantity, totallength From mrp_makingordersub
怎么将ACCESS 导到 SQL 里呀
1、查询Access中数据的方法:select * from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from serv_user')或select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\DB2.mdb";User ID=Admin;Password=')...serv_user2、从SQLServer向Access写数据:insert into OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from Accee表') select * from SQLServer表 或用BCPmaster..xp_cmdshell'bcp "serv-htjs.dbo.serv_user" out "c:\db3.mdb" -c -q -S"." -U"sa" -P"sa"'上面的区别主要是:OpenRowSet需要mdb和表存在,BCP会在不存在的时候生成该mdb
INSERT INTO opendatasource("Microsoft.Jet.OLEDB.4.0","f:\新建文件夹\11111\db.mdb";password=)
导入(MName,PasteBoardWidth,Quantity,TotalLength) SELECT MName,PasteBoardWidth,Quantity, totallength From mrp_makingordersub
select * from SQLServer表
或用BCPmaster..xp_cmdshell'bcp "serv-htjs.dbo.serv_user" out "c:\db3.mdb" -c -q -S"." -U"sa" -P"sa"'上面的区别主要是:OpenRowSet需要mdb和表存在,BCP会在不存在的时候生成该mdb