How can i export data in Xlsx format (1 Viewer)

[Shiv]

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.

 

[theDBguy]

Hi. Can Excel have more than 65000 rows?

Okay, I found this... I guess it could

https://support.office.com/en-us/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3

Let me keep looking.

Okay, looking around more, it seems to be a problem with the clipboard. How exactly are you transferring the data into Excel? Have you tried using the Export Data on the Ribbon?

 

[arnelgp]

maybe you are exporting to xls file which is limited to 65000 rows. in new xlsx you can have as many as 1million rows.

 

[isladogs]

If exporting using VBA, make sure you export using acSpreadsheetTypeExcel12Xml