34,593
社区成员
发帖
与我相关
我的任务
分享
--多了个逗号
insert
OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.4;User ID=sa;Password=password'
).mydb.dbo.tc
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:/test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
insert
OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.4;User ID=sa;Password=password'
).,ydb.dbo.tc
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:/test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$