Only Exporting 16384 records with Office '02 and Excel '03

S

Schwimms

How come it only lets me export this many records with the newer versions??????
 
J

Jerry Whittle

My original long answer seems to be lost. In a nutshell, don't use OutPutTo.
Instead using TransferSpreadsheet instead. You can readily chose which
version of Excel for the export. if memory serves, acSpreadsheetTypeExcel9
will allow 64K of records.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryA",
"n:\qryA.xls", True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top