EXCEL导入SQL
我将EXCEL导入到SQL中用如下语句报错"OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 报错。 [OLE/DB provider returned message: 找不到可安装的 ISAM。]
OLE DB 错误跟踪[OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]"
请问怎么解决,谢谢了
insert into Manuprice select * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=E:\工厂开发文件\11.XLS;User ID=;Password=;Extended properties=Excel 5.0')...Sheet1