Exporting more than 65K records to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to export a large amount of data to Excel, but the standard export
utility in Access will only let me export 65K at a time. How do I do a full
export of a large table without having to split the data up into separate
exports?
 
AFAIK you can't. It's not Access, it's Excel actually which imposes this
restriction: 65,636 is the maximum number of rows in an Excel sheet.
Split and export to several sheets within the same workbook is the best
you can do.

HTH,
Nikos
 
Darren,

As Nikos pointed out, it's a limitation of Excel not Access.

May I ask why you need to export such large amount of data to Excel? I can't
think of anything that you can do in Excel and can not do in Access. As a
matter of fact, the scenario is usually the reverse. You export FROM Excel
TO Access because of Excel's limitation (i.e. capacity is a common one). Not
the other way around.

Still, if you can establish a legitimate reason why you need to export all
that data then you can export to a text file. A text file will go beyond 65k
records.


HTH,
Immanuel Sibero
 
I need to import the data from Access to Oracle.

Immanuel Sibero said:
Darren,

As Nikos pointed out, it's a limitation of Excel not Access.

May I ask why you need to export such large amount of data to Excel? I can't
think of anything that you can do in Excel and can not do in Access. As a
matter of fact, the scenario is usually the reverse. You export FROM Excel
TO Access because of Excel's limitation (i.e. capacity is a common one). Not
the other way around.

Still, if you can establish a legitimate reason why you need to export all
that data then you can export to a text file. A text file will go beyond 65k
records.


HTH,
Immanuel Sibero
Click to expand...
 
Hi Darren,

Try exporting to the text file format. Oracle can read text file (CSV).
Actually, I have not had the opportunity to work with Oracle but surely it
can read text file.

Immanuel Sibero
 
Back
Top