Installable ISAM?

[Kay]

The following code returns: Run-time error '3170' Could not find
Installable ISAM.

I have never seen that one before. I dont even know where to begin. Any
help would be great. Thanks in advance.

Private Sub Command100_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "Contacts",
"C:\Edie\Contacts.xls", True
End Sub

 

[Clifford Bass]

Hi Kay,

Excel version 3 is really, really old. The converter for that version
may not be installed on your computer. How about choosing the newest version
from the list, as defined by the number at the end of
"acSpreadsheetTypeExcel"?

Clifford Bass

 

[Maurice]

Hi Kay,

See if this a provide you any pointers:

http://www.mvps.org/access/bugs/bugs0017.htm

hth