Problem with loading Excel Spreadsheet into Access database

[EdRev]

I got this error message when I try to import an excel spreadsheet into an access database:

"Couldn't find installable ISAM"

Any help would be greatly appreciated.

 

[RachelD]

An ISAM driver is what Access uses to get to file formats other than Access ones. Usually the error comes up because the path to a dll is incorrect or missing in the registry, or the dll itself is missing or corrupt.

You didn't say what version of Access you have, but here's a link to the microsoft knowledge base for resolving this in Access 2K:

http://support.microsoft.com/support/kb/articles/Q209/8/05.ASP?LN=EN-US&SD=gn&FR=0

I also once ran into this when I used a custom-built vb app that replaced one of the needed dlls.

here's the link for troubleshooting the error in access 97

http://support.microsoft.com/support/kb/articles/Q155/6/66.asp?LN=EN-US&SD=gn&FR=0

good luck
Rachel