Splitting table into parts and exporting into Excel using VBA

[Imo92]

I have a table which has about 30000 rows of records (although this amount does increase and decrease).
I am trying to export this table to an excel file. My problem is I require to split this table into three parts.

These three parts should be exported to individual excel workbooks, or one workbook which has three sheets, each having one part of the table.

I've used the docmd.transferspreadsheet method before, but unsure how to go about splitting the table.

Appreciate the help.

 

[mole999]

unless you are using 2003, 30,000 rows shouldn't be a problem and would live on a single sheet

 

[Imo92]

Thanks for your reply. I understand it can live on one sheet however let me explain myself a bit more.

The table is exported to an excel file, and then that export is uploaded elsewhere to another software application, where the excel sheet can only have a maximum of about 15000 records. That is why I require to split them.

Yes I can manually take that excel sheet and split it, but I was hoping to find a way to implement it using VBA, if possible.
Thanks