--用下面得到的字段和你的远程数据库的production表,对应的上吗?select * from opendatasource('Microsoft.Jet.OLEDB.4.0',
'Data Source="x:\yourexcel.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
'Data Source="x:\yourexcel.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
insert OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.18.102;User ID=sa;Password=sa'
).bc.dbo.product //远程数据表格
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\lym\桌面\生产计划导入表.XLS";User ID=Admin;Password=;Extended properties=Excel 5.0')...[product$]