不如把插入的字段列表列出来
insert into
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="c:\a.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$[name,age,account,cost]
select name,age,account,cost from aaa..money
insert into
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="c:\a.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$[name,age,account,cost]
select name,age,account,cost from aaa..money
服务器: 消息 170,级别 15,状态 1,行 9
Line 9: Incorrect syntax near 'name,age,account,cost'.