Export Access table to Excel that has more than 65000 records

  • Thread starter Thread starter duketter
  • Start date Start date
D

duketter

Office 2007. I cannot seem to export an Access 2007 table into Excel 2007
that has more than 65,000+ records. It stops and gives me an error.
Shouldn't I be able to export all 95,000 rows in my Access 2007 table into
Excel 2007 with the new row limits?
 
I am using Excel 2007 which has a 1,000,000+ row limit. The older Excel had
the row limit of 65,536.
 
How exactly are you exporting the records to Excel. As you said, Excel 2007
can hold a million rows. However hitting a limit of 65000 records looks
suspiciously like the export is in something like Excel 2003 or earlier.
 
duketter said:
I am using Excel 2007 which has a 1,000,000+ row limit. The older
Excel had the row limit of 65,536.

OutputTo always assumes Excel 97 format. Use the TransferSpreadsheet method
instead which lets you specify the Excel version.
 
Do you know if Microsoft plans to fix this so that you can export directly to
Excel 2007?

Also, where do you find the TransferSpreadsheet - I've looked in the Macro
settings, but was unable to locate.
 
I think you're find TransferSpreadsheet if you select Show All Actions. Jeff
Conrad explains at http://accessjunkie.com/faq_02.aspx

Given that you CAN export to Excel 2007 using TransferSpreadsheet (the
preferred way of dealing with spreadsheets), I doubt you'll find any change
is planned.
 
Back
Top