DoCmd.TransferSpreadsheet problem 1

[Lhuffst]

I have a fe/be 2003 database that was able to use the docmd.transferspreadsheet without problem.
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

 

[sxschech]

I had a problem when upgraded to Access 2013. I tried using current version of excel and got error, so ended up using Excel9, an earlier version of excel format and that worked. Last week I had seen some code on a forum that solved the problem of being able to save to a more current version of excel format. Perhaps it will work for you. Add Xml to the ExcelType if using any format above acSpreadsheetTypeExcel9. See below:

[tt][pre]acSpreadsheetTypeExcel12Xml[/pre][/tt]

If your goal is to save to an earlier version (you show 4 in your example), then you may need to try a number higher than 4 until you no longer receive the error.

 

[Lhuffst]

sxschech. Thanks for the example, I changed it to acspreadsheettypeexcel12 and it seems to work.