import excel into sql - Could not find installable ISAM

[Hueby]

Hi all,
Hi Everyone,

Trying to import Excel 2003 into SQL 2000 with this code:

Insert into IM_ITEM_MASTER_MC Select * FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0','Excel 11.0;Database=C:\testing.xls;HDR=YES','SELECT * FROM [Sheet1$]')

When using Excel 8.0 I got this error:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IColumnsInfo::GetColumnsInfo returned 0x80004005: ]

I thought because of using Excel 2003 I need to change it to Excel 11.0, then I get this error:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].


So far I have tryed to register some DLL files, and reinstall Office 2003. Any ideas, help????

 

[RoyVidar]

I had a little look at

http://support.microsoft.com/default.aspx?scid=kb;en-us;306397&Product=sql

and made something work according to the sample there. Playing with your sample - try something like this (similar worked in my QA) - but isn't this more a SQL server question than Access?

[tt]Insert into IM_ITEM_MASTER_MC Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\testing.xls;HDR=YES',Sheet1$)[/tt]

Roy-Vidar