I am running Office 2010 under Windows XP SP3 and I am getting the above error while exporting data from Access to Excel via a VBA routine. It worked fine in Access 2000 but since upgrading to Access 2010, I have started to get the erro "Could not find installable ISAM".
I am using a statement that starts DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3
If I change it to acSpreadsheetTypeExcel5 (or later) then it works fine but 3 or 4 brings up the installable ISAm error.
Any help as to how to make 3 and 4 work would much appreciated.