SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
try: select * into newtable from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\xyz.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheetname$
SELECT * into AA FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="路径";Extended properties=Excel 5.0')...sheet1$
就这个问题,我也想请教一个问题,我的代码如下: SELECT * into AA FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Extended Properties=Excel 8.0;HDR=YES;IMEX=1;DATABASE=c:\test.xls')...sheet1$一直都有一个错误提示: OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 报错。 [OLE/DB provider returned message: Could not find installable ISAM.] 请问改如何解决? 我参考了,邹建 的帖子,但是结果也出现了相同的错误: 错误号 错误源 错误描述 0x80004005 Microsoft Jet Database Engine Could not find installable ISAM
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
select * into newtable
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\xyz.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheetname$
'Data Source="路径";Extended properties=Excel 5.0')...sheet1$
SELECT * into AA FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Extended Properties=Excel 8.0;HDR=YES;IMEX=1;DATABASE=c:\test.xls')...sheet1$一直都有一个错误提示:
OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 报错。
[OLE/DB provider returned message: Could not find installable ISAM.]
请问改如何解决?
我参考了,邹建 的帖子,但是结果也出现了相同的错误:
错误号 错误源 错误描述
0x80004005 Microsoft Jet Database Engine Could not find installable ISAM
select col1,col2,.... from
OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\收费标准.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet3$]