Access 2003 import Excel 2007 file

[Rialtus]

I have a client who is currently running Access 2003. The client has the
Office 2007 Compatibility Pack installed as well. She receives an Excel
file that she imports into her Access 2003 database, and all used to be
great in the world, until the source started using Office 2007. The file
is now in native Excel 2007 (XLSX) format, and the person using Access
2003 can not natively import that file.

Currently, she is opening the file in Excel 2003 (remember the Compat.
Pack?), saving it in native Excel 2003 (XLS) format, then importing the
file into Access 2003. This client can not upgrade to Office 2007.

Is there an easier solution to this issue? Or is the client stuck with
downgrading the file format until she can afford Access 2007?

 

[Guest]

http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891.

That should give you ODBC and OLEDB drivers, using the
new ACE engine, which you MAY be able to use to create
a linked table, and which you SHOULD be able to use in
code to create an ADO (OLEDB) import function.

Normally, you can't do an ODBC linked table connection from
Access 2003 to XLS, but you can try using the new ODBC
driver because it is an ACE driver instead of a Jet driver.

The Access direct import of xls goes through the Jet database
engine, and then back into an Access DLL, so I doubt if there
is anything that can be done to fix A2003 short of upgrading to
2007.

Or the XLSX format is a text format, and you could write your
own XML import function....
(david)