How can i export data in Xlsx format

Shiv

Registered User.
Local time
Today, 12:40
Joined
Dec 23, 2018
Messages
16
i have 300000 rows in access query and when i am exporting this Database then access is exporting only 65000 row.

i want to export the Database in Xlsx format so that all 300000 row could be export in a single excel workbook

thanks in advance for nice support.
 
Last edited:
maybe you are exporting to xls file which is limited to 65000 rows. in new xlsx you can have as many as 1million rows.
 
If exporting using VBA, make sure you export using acSpreadsheetTypeExcel12Xml
 

Users who are viewing this thread

Back
Top Bottom