Avatar of Anthony Mellor
Anthony Mellor
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Unable to get ODBC working on Mac (and many years trying) - Excel 2011 et al

I think I need help from someone who has succeeded in getting ODBC working for the purpose of using Mac Excel to query Mac Excel files - that is ALL I want to do.
This is a matter that neither Microsoft or Apple provide a solution for and as such two third parties have stepped in, but I get nowhere with either despite everyone's best intentions.

My previous thread is here:
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_28040132.html

That thread provides screen shots and explains everything I have tried, with game assistance from an answerer, but we did not succeed.

As such this question is quite possibly my last resort.
I have spent a great deal of time not solving this issue.

Any help will be gratefully received.

Anthony
Microsoft ExcelMac OS XMicrosoft SQL Server

Avatar of undefined
Last Comment
Anthony Mellor

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dave Baldwin

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
Dave Baldwin

I just found this that was posted last week on CNET: http://download.cnet.com/ODBC-Manager/3000-20432_4-10967170.html  I have no idea whether it's any good, I haven't tried it.

This is their real homepage: http://www.odbcmanager.net/
Anthony Mellor

ASKER

yes, was 1st step.

I just found this that was posted last week on CNET: http://download.cnet.com/ODBC-Manager/3000-20432_4-10967170.html  I have no idea whether it's any good, I haven't tried it.

This is their real homepage: http://www.odbcmanager.net/

yes, these are for an ODBC Manager, they are not for the necessary driver.

That's one of the problems, on the 'net there is no distinguishing between the ODBC Manager app that Apple chose no longer to include and the Drivers that they never included.  

As such it is easy to spend hours searching for the wrong thing. As a result I have multiple ODBC Managers and zero drivers.

When I download drivers, such as Actualtech and Openlink, I don't get very far.

Incidentally the driver does not have to be free, just not the $200 an hour Openlink want.
Dave Baldwin

I didn't see anything for Excel, just for MySQL and the UnixODBC/FreeTDS for MS SQL.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Anthony Mellor

ASKER
I believe my trouble lies in understanding how to install what I already have; while also understanding which of what I have is the right component. I say this only because I have long had all the components from both the suppliers mentioned in your first link.

As such I need to find someone who has successfully completed the ODBC Driver install process. A rare animal indeed it seems.
Dave Baldwin

What shows up in your ODBC manager?
Dave Baldwin

Just for a test, I downloaded and installed a MySQL ODBC connector and the ODBCManager software on my MacBook Pro 10.6.8.  When I run the ODBC Manager, all I see is the MySQL driver.  I do have a version of Microsoft Office 2004 and Libreoffice on my computer.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Anthony Mellor

ASKER
I wish it were that simple; I just tried to do that and there are so many tabs all with details and further dialogues I get lost.

Suspect I need to uninstall everything and start again, which itself is a problem.

Actualtech is I think the one I need to use and I should uninstall the OPenlink stuff.
Actualtech's Access drive includes Excel, csv and some others, but seems not xlsx

There is quite a lot of stuff on the internet about connecting to various databases, but not for Excel. At least not that I have found.

If you manage to get ActualTech's Access/Excel driver working for Excel do tell me how, please.
Dave Baldwin

The first tab you need to look at is always Drivers.  If the driver isn't listed there, it's not installed or available anywhere else.

I don't have any reason to buy the Actualtech drivers.
Anthony Mellor

ASKER
Apologies, I wasn't suggesting you buy anything.

I have deleted the Openlink stuff manually now and will see if I can report back with some screen shots.

Yes , it took me ages to realise drivers need to be present in the drivers tab. Now I get lost with their configuration, which I am hoping was being complicated by having two different sets present.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Dave Baldwin

On this page http://www.actualtech.com/products.php , it says...

The driver supports Access 97 or later, including Access 2003.
I think that 'xlsx' starts with Office 2007.  If that's true, it's not supported.
SOLUTION
Anthony Mellor

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
Anthony Mellor

ASKER
I just sent this email to Actualtech, maybe it will inspire a response here or there that helps me get past my "block". Regrettably my frustration probably shows through, I just hope not too much. I feel so stupid with this matter.

Their "readme" is here:

http://www.actualtech.com/readme.php


On 16 Apr 2013, at 11:34, Anthony Mellor  wrote:

Hi,

Support ODBC Excel 2011 to Excel Various Mac OSX 10.8.3

I have spent many YEARS trying to use ODBC to use MS Query from within Excel to query other Excel files located in the same directory as the file from which I am making the query.

I have never succeeded in getting through the ODBC Configuration requirements and usually get no further than the part that asks for database name (ok that can be anything) and then login details and location. Excel files do not have login details and the location is always the current directory for the file I am using.

Doubtless the solution is simple. However, I continue to fail and write to plead for help.

Be sure to include the following information in your e-mail:
A description of the task you are attempting to perform - Query Excel files from an Excel file
What you expected to happen - MS Query results drawn in from Excel files and sheets.
What actually happened - nothing
Your name and product license key (if applicable) - evaluation, happy to pay if it works as I need.
Which version you are using - latest, whatever that is.
Which version of Mac OS X you are using - latest
Which server OS and database version you are using OSX and .. database?! There's the problem. I wish to Query Excel files from Excel, just as I do on my PC. How hard can it be? :-)
 Thanks

Anthony
PortletPaul

>>Actualtech have released a new driver yesterday
let's hope it solve this age old problem for you.

Best of Luck,
Paul
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Anthony Mellor

ASKER
thanks, working on it as we type - I'll put the end result in here for any future searchers.
Anthony Mellor

ASKER
The only real solution is the link in the answer provided, the rest is a case of support required from the suppliers. Actualtech have released a new driver yesterday .