这样可以通过
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\help\桌面银行余额调节表.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
但是...[Sheet1$]或者...xactions是什么意思
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\help\桌面银行余额调节表.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
但是...[Sheet1$]或者...xactions是什么意思
[Sheet1$]