SELECT * into AAA
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source="D:\FOR USHER\aaa.xls";
User ID=Admin;Password=;Extended properties=Excel 5.0')...[sheet1$]
报错:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "無法指出的錯誤".
Msg 7303, Level 16, State 1, Line 6
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".不知道什么原因?
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source="D:\FOR USHER\aaa.xls";
User ID=Admin;Password=;Extended properties=Excel 5.0')...[sheet1$]
报错:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "無法指出的錯誤".
Msg 7303, Level 16, State 1, Line 6
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".不知道什么原因?
FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\FOR USHER\aaa.xls;
User ID=Admin;Password=;Extended Properties=Excel 8.0;')...sheet1$
SQL SERVER 2005 EXCEL2003=11.0
执行的时候我用的是11.0,发帖贴错了...