Sounds to me like you should be using SQL Server and an ETL tool
so so so so so very sorry that Access is stuck in the stone ages



On May 10, 7:07*pm, zyus wrote:
I'm using Access & Excel 2007.

When i try to export data to excel from my query, the number of records is
only limited to 65000 rows.

I thought that 2007 excel can handle more than 65000 rows.

Appreciate any advise.

Thanks