首先在Access中建立与sql server 相同的表结构,然后在查询分析器中写入
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'F:/Intepub/wwwroot/demo/UserManager/Admin/UserManageInfo.mdb';'admin';'',accessTableName)
select gjmc,dm,wtwjm,imgOrder from sqlTableName
首先在Access中建立与sql server 相同的表结构,然后在查询分析器中写入
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'F:/Intepub/wwwroot/demo/UserManager/Admin/UserManageInfo.mdb';'admin';'',accessTableName)
select gjmc,dm,wtwjm,imgOrder from sqlTableName