OutputTo Excel limitation?

[baloos]

Hi,

Access 2000. I get error 2306 when using Docmd.OutputTo

"There are too many rows to output, based on the limitation specified by the output format or by " my database.

19k rows to export. I am able to do this manually using the Export menu, but I need to do this programatically. What limitation is kicking in, and is there a way around it?

Any help appreciated, thanks.

 

[neileg]

Access 2000 assumes that you are exporting to Excel 5.0 (95 or 97). This only supports 16k rows. Don't ask me why it doesn't use Excel 2000 which supports 64k rows.

There's a article in MS Knowledgebase, I think, but as far as I can remember there's no solution!

 

[ghudson]

You should use the TransferSpreadsheet method to export your record source to an Excel file.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, "YourQueryHere", "C:\Test\MyFile.xls", True

Check the help files for the TransferSpreadsheet method for more options and info.

HTH

 

[neileg]

Thanks, ghudson. I learned something new.