OpenDataSource查询本地excel表，User ID和password怎么填？

[freshman]

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\total.xls";User ID=admin;Password=sa;Extended properties=Excel 5.0')...xactions

User ID和password怎么填？

谢谢！

[friendliu]

User ID=admin;Password=;

[txlicenhe]

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

[youngby]

回答了。

[pengdali]

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
删除：
DELETE
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions


注意，你查询的时候不要用同时用excel打开这个文件。

[zjcxc]

user id=admin;password=

[zjcxc]

或用openrowset

select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=F:\My Documents\客户资料.xls',全部客户$)