We help IT Professionals succeed at work.

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

234 Views
Last Modified: 2017-03-19
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?
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT

Author

Commented:
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 TsioumprisIT Supervisor
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
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)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<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.
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.
CERTIFIED EXPERT

Author

Commented:
Thanks to all participants!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions