Link to home
Start Free TrialLog in
Avatar of bfuchs
bfuchsFlag for United States of America

asked on

Is there a way to link Access 2003 app to an xlsx sheet?

Hi Experts,

I'm using Access 2003 and looking for a way to link a spreadsheet created I guess with later version of Excel.

The problem is that I dont get an option to see all file types (*.*) under the Link wizard, so how can this be accomplished?
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

Hi,
MS created a converter or viewer for the .xlsx (or maybe it was just .docx) file type.  If that is available, you might be able..
Yes, that is avail and I'm using it to view contents of file, so perhaps there is hope..
Once you change the format, no old version of the app can use the new file.
FYI- Its not the file ext that's causing the problem it's just the office version, I tried doing it from a pc with Access 2010 and still couldn't, see attached.

Thanks,
Ben
Untitled.png
You using Access 2010 but your application is still Access 2003...If you transfer it to 2010 then you can link the Excel to Access..
<<The problem is that I dont get an option to see all file types (*.*) under the Link wizard, so how can this be accomplished?>>

  As Pat said, it cannot.   The ISAM driver in 2003 that allows for linking an Excel spreadsheet as a "table" only understands the .xls format.

 This is separate from the compatibility pack that allows you to use Excel 2003 to open an .xlsx file type.

 Pat was also correct in saying that automation might be an approach; it will work.   There, your using Excel itself to read the spreadsheet and with the compatibility pack, that will work.

 Other option is to get the creator of the spreadsheet to either save in .xls, or .csv

 No points please.

Jim.
Thanks Jim for confirming that OLE automation could work.

@bfuchs,
If you can convert the app to the .accdb format, that will solve the problem.  Otherwise, use my automation suggestion to have Excel open the .xlsx and save it in the .xls format.  Then your A2003 app will be able to link to it.
Avatar of bfuchs

ASKER

Thanks to all participants!