Exporting data from Access to Excel programmatically

[glab]

Hello everyone,

I have a question for you. Let's say I have a table in Access database and it has 100,000 records. I'd like to export this table's data to Excel spreadsheet. Docmd object has methods/actions OutputTo and TransferSpreadsheet to help to do this. But Excel has limits the number of rows - 65536 - per worksheet. Is there a workaround to solve this problem?
Please, any info or pointers will be greatly appreciated.

Thank you in advance.

 

[SkipVought]

Limit the data to 65,536 rows MAX per sheet.

THAT'S what you're working with.

It's the Sheet Limit for Excel.

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]