Could not find installable ISAM

[sdc248]

Hi:

I got an error message when I am trying to have a stored procedure import a table from an excel file. It's a SQL Server 2005 and I have enable the Ad Hoc Distributed Queries option. The query I am testing is as below:

SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet. OLEDB.4.0',
'Data Source=S:\myfil e.xls;Extended Properties=Exce l 11')...TEST$

The error message:
OLE DB provider "Microsoft.Jet. OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet. OLEDB.4.0" for linked server "(null)".

What could be the problem? Thanks.

[Reshmi Jacob]

Hello

I have encountered the same problem while accesing from VB and access, I don't know how with SQL! Still what I did in my case is to run set up of Visual Studio and install the component in section Data Access - Jet IISAM. Try and see if this is of any help to you

Regards
Reshmi