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

From: Shamil Salakhetdinov <shamil@marta.darts.spb.ru>
To: ACCESS-L <ACCESS-L@PEACH.EASE.LSOFT.COM>
Subject: Re: installable ISAM (II)
Date: 22 February 1999 12:48

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


HOME    TOPICS

Copyright © 1999 by Shamil Salakhetdinov.
All rights reserved. Terms of use.

Last updated: October 10, 2006

Published also here at 4TOPS: Couldn't find installable ISAM (Excel)