Excel export error in MDE but not in MDB
Posted on 2014-10-29
I'm having trouble with a particular line in a Acc2003 database - running on a pc with Acc2010.
The line below throws a "ISAM could not be found" when running the database as a MDE - when using a MDB everything is fine. Any ideas how to solve/Work around this ?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qry_ExportAll", "c:\testfile", True