Hi all,
I'm getting this error message below, when trying to use openrowset to import in data from Excel sheet.
Everything works fine for a few months then I start getting this error. If I restart SQL Service everything works fine again.
Can someone please tell me what is being cleaned up so I can do this without restarting the SQL Service?
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)".
thanks,
gv