make sure your file name is correct, "DailyReport.xlt" or "DailyReport.xls"? and make sure the file exist, then tryselect * from opendatasource
('Microsoft.Jet.OLEDB.4.0','Data Source="C:\DailyReport.xls";Extended properties=Excel 8.0')...sheet1$
('Microsoft.Jet.OLEDB.4.0','Data Source="C:\DailyReport.xls";Extended properties=Excel 8.0')...sheet1$
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...A ---工作表A