Any chance mdb to get data from xlsx

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
I know accdb is better to be used to get linked data from xlsx.
But for some reason my platform can only use mdb.

Anyone got any experience mdb can also get linked table data from xlsx ?
Help...
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,264
it should be trivial. have you checked the help files, or googled?
 

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
it should be trivial. have you checked the help files, or googled?
Yes I have tried Google and no luck.

I tried in mdb link to xlsx it says this version of access cannot link to this newer xlsx. Seems mdb can link xls (older version of xlsx) only.
Anyone can have a way out in this case ?
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,264
It is a surprise if Google didn't find the answer; but maybe you have the answer already directly from the error message.

An old version of Access & new version of Excel? For anyone to be able to advise, best you give some further explanation.
Such as which versions of the software you are using

 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,604
Office Version
2013
Platform
Windows
I also believe that you can't use the new (now old?) xlsx formats with Access 2003 or earlier. mdb is strictly speaking just a file format, but Access 2003 and earlier cannot read or write the new xml-based file formats introduced in Office 2007.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,889
Messages
5,411,039
Members
403,337
Latest member
lgjohan

This Week's Hot Topics

Top