SQL Server Performance Forum – Threads Archive
Could not find installable ISAMDear All, I’ve got one excel file with name test in c drive (c: est.xls). That sheet has got two columns No, Name with some records. Now, I want to select that records,i.e. from excel sheet in sql statement. I’ve used OPEN QUERY , OPEN DATASOURCE etc. functions, but the following error is coming: OLE DB provider ‘Microsoft.Jet.OLEDB.4.0’ reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]
Can any one help out to sort this problem?
Using DTS works fine?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Kindly do not post multiple(duplicate) posts in the forum.
Continue discussion inhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2274 here.