CURE: Export more than 65000 lines access to excel

oliviar

Board Regular
Joined
Sep 12, 2010
Messages
184
Hi Guys,
I thought I'd post a reminder of the cure to this problem. In case someone else searches for it. It was the bane of my existence yesterday.

If your query or table has more that 65000 you can only export it without formatting. And you may have to create a new file name (it doesn't seem to appreciate copying over the top of an old file).
Export it without formatting, and as an xlsx or csv file, and all your data will show up.

;)
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,108,655
Messages
5,524,135
Members
409,562
Latest member
meeranaskar

This Week's Hot Topics

Top