Export To Excel sheets limited to 65,000

[arryb]

I am trying to write some code to export a query from a MS Access database to Excel 97. The problem being that the query is often well over 65,000 lines long and as such will not fit into excel.

If more than 65,000 records exist i want to start a new worksheet. This needs to operate in a loop to input new sheets however often they are needed.

I have dabbled in obtaining this in various ways with no success.

Can anyone help?

Thanks

Arry