Could not find installable ISAM

[ropewrench]

I just started receiving this error after 3 months of flawless operation
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]

Here is the code that is being processed
declare @dosStmt varchar(200)

set @dosStmt = ' del h:\autoemailtemp\ChemStar_NS_Status.xls '
exec master..xp_cmdshell @dosStmt
--GO

--declare @dosStmt varchar(200)
-- Create an Empty Excel file as the target file name by copying the template Empty excel File
set @dosStmt = ' copy h:\autoemailtemp\ChemStar_NS_Status_Temp.xls ' + 'h:\autoemailtemp\ChemStar_NS_Status.xls'
exec master..xp_cmdshell @dosStmt
--GO

--EXEC sp_dropserver 'Excel1', 'droplogins'
-- Create a "temporary" linked server to that file in order to "Export" Data
EXEC dbo.sp_addlinkedserver 'Excel1',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'h:\autoemailtemp\ChemStar_NS_Status.xls',
NULL,
'Excel 8.0'
--'Excel 5.0'
--GO
EXEC sp_addlinkedsrvlogin Excel1,FALSE,NULL,NULL,Null

--GO

declare @tsqlStmt varchar(500)

-- construct a T-SQL statement that will actually export the query results
-- to the Table in the target linked server

set @tsqlStmt = 'Insert Excel1...[TEST]' + 'SELECT Warehouse,VENDOR,PRODUCT_CODE, PROD_DESC, LOCATION_CODE,LOT_CODE, NS_STATUS From [Priya].dbo.RinNSStatus'
print @tsqlStmt

-- execute dynamically the TSQL statement
exec (@tsqlStmt)

-- drop the linked server
EXEC sp_dropserver 'Excel1', 'droplogins'

respectfully,
ropewrench

 

[NoCoolHandle]

It sounds like an MDAC problem related to your version of Excel...

it might be a good idea to try installing the latest version of MDAC (Microsoft Data Access Component)..
Go to

http://www.microsoft.com/downloads/...95-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

if that doesn't work, check the path to your excel file is correct.


HTH

Rob

 

[ropewrench]

Thanks for the tip, we will try the MDAC to see if that makes a difference. We did verify that the path is correct for the files, so that is not the issue. In the link you provided the overview states: "This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or the Visual FoxPro ODBC Driver."
Will this make a difference?

respectfully,
ropewrench

 

[NoCoolHandle]

You might want to look at an earlier verison of mdac..
It might take a little searching, but you should be able to find one. 2.6 or 2.7 should be ok..

I didn't notice the warning..(sorry)

I also did some playing around on my server...
I have xl 11.0 installed and managed to get the same error (isam etc...) when specifying the correct version 11.. 8.0 gave me a column error..

Have you reciently upgraded your version of office? Could this be the issue?

Rob