2,495
社区成员
发帖
与我相关
我的任务
分享
insert OPENDATASOURCE('SQLOLEDB','Data Source=127.0.0.1\MSSQL;User ID=sa;Password=123456').TMS.dbo.seres
SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data
Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...[Sheet1$]
adoquery1.sql.text:='insert OPENDATASOURCE(''SQLOLEDB'',''Data Source=127.0.0.1\MSSQL;User ID=sa;Password=123456'').TMS.dbo.seres SELECT * FROM OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 8.0'')...[Sheet1$]'
);
adoquery1.excute;