TutputTo limitation

[alexogir]

I'm having poblems with exporting a tabe to excel format. Whn I try to use OutputTo Command I get error message saying "There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access". Is there any way to avoid that limitation or to change it. I'm trying t export the table with 70000 recordds.

Thanks in advance

 

[yellow]

Excel is probably your problem. The maximum number of rows used to around 65,000. Not sure if the newer version of Excel handle more rows.

 

[ghudson]

Excel 2003 still has the 65,536 row limitation.

Output your data to a text file [TransferText method] or limit [query criteria] your output.