ExcelBanter - Limited in Exporting Access to Excel to 65,000 Rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Limited in Exporting Access to Excel to 65,000 Rows (https://www.excelbanter.com/excel-discussion-misc-queries/181652-limited-exporting-access-excel-65-000-rows.html)

den4673

Limited in Exporting Access to Excel to 65,000 Rows

I am using MS Office 2007 and am trying to export approximately 85,000
rows from MS Access to MS Excel but it is limiting the export to
65,000 rows. The database has a .accdb extension and the Excel file
has an .xlsx etension.

I have been unable to find out what I am doing wrong and any
assistance would be greatly appreciated.

Den

All times are GMT +1. The time now is 02:35 AM.