Avatar of bfuchs
bfuchs
Flag 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?
Microsoft AccessMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
bfuchs

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
John Tsioumpris

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..
Jim Dettman (EE MVE)

<<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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
PatHartman

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.
bfuchs

ASKER
Thanks to all participants!