SELECT * into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\qts\qts.XLS";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions from [JL送检单表头]
'Data Source="C:\qts\qts.XLS";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions from [JL送检单表头]
按照你的运行出错:
在关键字 'OpenDataSource' 附近有语法错误。
exec master..xp_cmdshell 'bcp "select * from 表 where ..." queryout ........'
改用楼上两位的:导入/导出向导或BCP