Exporting a table from Access 2003 to Excel 2007

[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?

 

[Jerry Whittle]

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.