Exporting more than 65K records to Excel

[Darren]

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?

 

[Nikos Yannacopoulos]

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

 

[Immanuel Sibero]

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

 

[Darren]

I need to import the data from Access to Oracle.

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

 

[Immanuel Sibero]

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