The following give me "couldn't find installable ISAM" error message on a new machine.
Docmd.TransferSpreadsheet acImport, 8, "GapImport", Mypath1, True, "A1:L2000"
The previous machines originally had Office 2000, then upgraded to Office XP (10) now they have 2003 (11). Our new machines start with 2003. We do still use Access97. I believe it might be the references to Microsoft Office Library (10) is not installed. Currently I have Office 8 selected but get the error. Any ideas are appreciated.
Docmd.TransferSpreadsheet acImport, 8, "GapImport", Mypath1, True, "A1:L2000"
The previous machines originally had Office 2000, then upgraded to Office XP (10) now they have 2003 (11). Our new machines start with 2003. We do still use Access97. I believe it might be the references to Microsoft Office Library (10) is not installed. Currently I have Office 8 selected but get the error. Any ideas are appreciated.