Export to Excel

[welcomesui@gmail.com]

Hi All,

I have a table that contians more than 70,000 rows, where I want to export the table as two different excel files.

1. One excel file data from 1 to 65000 rows
2. Second excel file from 65000 to end of table.

Can any one help in this regard.

Regards,
HARI

 

[spikepl]

Make a query that gets the desired records and use that query for TransferSpreadsheet

 

[welcomesui@gmail.com]

Hi Spikepl,

Can I let us know how to write this query.

Regards,
Hari

 

[speakers_86]

He couldn't possibly know how to answer that. However, Access has a very nice GUI for SQL. You can try it out yourself without hurting anything as long as you stay with SELECT queries. If your worried about messing it up, make a copy of your database and work with that one. For more detail on making queries, search Google or even YouTube.