Couldn't find installable ISAM (Excel)


Question

I received the message "couldn't find installable ISAM" which probably means I am missing a part of Access but after several installations my program still isn't finding it. Error occured executing (has worked for months)

DoCmd.TransferSpreadsheet acImport, 6, "Filey", strFile, False

Anybody run into something like this?

Answer

Dick,

Probably both registry keys or only the second registry key are/is missing
on your PC:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel]
"win32"="C:\\WINNT\\System32\\msexcl35.dll"
"ImportMixedTypes"="Text"
"FirstRowHasNames"=hex:01
"AppendBlankRows"=dword:00000001
"TypeGuessRows"=dword:00000008

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM Formats\Excel 4.0]
"Engine"="Excel"
"ExportFilter"="Microsoft Excel 4 (*.xls)"
"CanLink"=hex:01
"OneTablePerFile"=hex:00
"IsamType"=dword:00000001
"IndexDialog"=hex:00
"CreateDBOnExport"=hex:01
"ResultTextExport"="Export data from the current database into an Excel 4
file.  This process will overwrite the data if exported to an existing
file."
"SupportsLongNames"=hex:01
"ImportWizardFunction"="mx_entry"
"WizardProject"="wzlib80.mde"

HTH,
Shamil


Copyright 1999-2008 by Shamil Salakhetdinov. All rights reserved.