Output to Excel (over 65535)

[schweer]

Howdy:

I know little-to-nothing regarding VBA, syntaxwise, so bear with me. Here's what I need to do. I'm running Access 2000, first off.

I've got a file that's processed and needs to be exported to Excel for report purposes). In certain cases, the file may be larger than the 65535 record Excel allows. How can I bypass this? I tried to open the VB Editor on a macro, thinking I could just take care of the problem there, but that didn't seem to work.

Initial thoughts are for 2+ tables, depending on the number of entries.

Any help is greatly appreciated.

Matt

 

[modest]

I think this problem has already been addressed on this forum. Do a search.

65535 is the maximum amount of rows you can have on an excel sheet. To get around this you'll have to spread your data across multiple sheets

Load a recordset in VB.. export the first 65535 (if there are more records after that)then create a new sheet and export more .. and so on.

Again do a search on the forum to possibly get a better solution.

 

[schweer]

Thanks Modest, I'll do a search.

Feel free to lock/delete this thread. If my question is not answered, I'll post a reply or a new thread.

Thanks again.

-Matt