How can I make Access 2003 work with excel 2007 files?

[Chris Mitchell]

When I go File > Get External Data > Import from within Access 2003 it only lists excel 2003 files, i.e. .xls. It doesn't list, or let me select Excel 2007, .xlsx, files which areon my PC and I need to use because of the volume of data.

Similarly when I try to Export from Access 2003 it won't let me save to ..xlsx files.

How can I make Access 2003 work with excel 2007 files?

TIA.

Chris.

 

[Arvin Meyer [MVP]]

Access 2003 cannot ever see an .xlsx file. You'll need to save those files
as the earlier format to use with earlier product versions. There is a
conversion program on Microsoft's site for a read-only conversion for those
who do no have Office 2007.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


When I go File > Get External Data > Import from within Access 2003 it only
lists excel 2003 files, i.e. .xls. It doesn't list, or let me select Excel
2007, .xlsx, files which areon my PC and I need to use because of the volume
of data.

Similarly when I try to Export from Access 2003 it won't let me save to
..xlsx files.

How can I make Access 2003 work with excel 2007 files?

TIA.

Chris.

 

[Chris Mitchell]

Thanks Arvin.

Guess I'll have to continue saving them as .csv and Importing those to
Access, and the reversing the process to save them.

I can't use E2003 as the files are too big and exceed the limits.

 

[Tom van Stiphout]

On Mon, 9 Feb 2009 12:55:53 -0000, "Chris Mitchell"

Applications rarely are forward compatible, and A2003 is not an
exception.
Use an XLS file instead.

-Tom.
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

You can import and export as text (txt) files and change the extension to
..csv and just open the file in Excel 2007 and save as an Excel file.

While Access may not be able to read or write to Excel 2007, you may be able
to set a reference to Excel 2007 and use automation to open and save the
Excel file.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com