Export to excel

[Reggie]

Hi and TIA. I'm trying to export a query, but get an error stating "to many
rows to output based on the limitations specified by the output format or my
database". I'm using A2K and Excel2000. The number of rows is @20,000. If
I export say 13,000 it works. I know the limitations of excel is around
65,536 rows by 256 columns. Code is below. Nothing fancy. Any advice is
appreciated. Thanks for your time.

DoCmd.OutputTo acQuery, strQuery, "MicrosoftExcel(*.xls)", , True


******************
Reggie

 

[John Spencer]

Output To conforms to an older version of Excel which only allows 16K
records (rows in Excel). You can try using

DoCmd.TransferSpreadsheet ...


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Hi Reggie

OutputTo uses an older Excel format has a limit of 16384 rows.

Use TransferSpreadsheet which allows several formats.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strQuery,
"your_filename.xls"

Regards

Andy Hull

 

[Reggie]

I looked at that but didn't know of the difference. Thanks all for the
help.