Exporting limitations in Access

[Guest]

Hi,

I'm getting an error message when I run a simple macro (SaveToFile) to
export a table with approx 45 KRows and save it to .xls format. The error
message is: "There are too many rows to write the information, based on
limitations in the outdata format or in Microsoft Access". The error message
appears when the table to be exported has more than 16383 rows. I have
converted the macro into Visual Basic with the same result!
When I do the it manually by using Archive - Export it works fine!

I am confused! Why can't I export a table with more that 16383 rows when I
use Visual Basic / Macro

Windows XP, Access 2002, Excel 2002

Any guidlines will be appreciated!

 

[Guest]

Different versions of Excel had different limitations on the number of rows.
If you are using OutputTo I believe that it sends the file as Excel 3 by
default which allows only 16K records. If you use OutputTo in a Macro, you do
have the ability to chose later versions of Excel.

The TransferSpreadsheet Action defaults to Microsoft Excel 8-10 which allows
around 64K records.