Our company has upgraded to office 2010 and now this step is giving me the error "cannot find installable isam".
I changed the code to reflect the new office version but that didn't help. Does anyone know what I need to change?
The database has not been converted to .accdb format.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel4, _ "TblInternalAudit", "\\cobwin02\FHMeterRental\FireHydrant Database\FHExport\AccountingGroup.xls", True