Exporting a table from Access 2003 to Excel 2007

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I am trying to export a table from Access 2003 with more than 100,000 records
into Excel 2007 and am not having any luck. I do not find the 2007 file
extension in the drop down and choosing the latest version only exports part
of the table. Any thoughts on whether this is possible to do?
 
Hi Carol,

This is even hard to do with Excel 2007. You won't be able to do it directly
with Excel 2003. You could export the file as a comma separated value with a
csv suffix. By default Excel usually opens csv files. However you may lose
formatting and other stuff.

I just tested this by exporting 750,000 records from an Access 2003 database
and naming the file cargo.csv . When I went though the export wizard, I
chose delimited with a comma, " as the text qualifer, and Include Field Names
on First Row. I then moved this file to PC with Office 2007. Double clicking
on the file opened it with Excel and the file looked good.
 
Back
Top