Mac Excel and MySQL connectivity

[Matthew Leingang]

Hello,

I am trying to query a MySQL database with Excel 2004. I understand that
they both talk ODBC, but I'm fuzzy about how this works. I'm looking for a
howto for doing this on a Mac.

I installed an ODBC driver for MySQL, and it tests fine through its version
of the ODBC administrator. But when I try to query the db in Excel it tells
me there is no driver installed. Do I also need to install one for Excel?
If so, where do I get one? A google search on "excel odbc driver" turns up
a lot of noise and little signal.

Thanks for any advice, pointers, directions on where else to look or ask.

--Matthew Leingang

 

[Jim Gordon MVP]

Hi,

This URL might get you started:

http://www.microsoft.com/mac/produc...IBRARY/how_to_articles/office2004/xl_ODBC.xml

-Jim

 

[Matthew Leingang]

Dear Jim,

Thanks for the pointer. I had actually found that before. I'm glad to know
that the solution is at most $29.95 away.

I think I'm confused about OBDC in general. Do both client and server need
an OBDC module to communicate?

I'll go ask on the MySQL list. Thanks for listening!

--Matt

 

[Jim Gordon MVP]

Hi Matthew,

The client needs to have an ODBC driver. There needs to be a file path
connection to the server (often a network connection). The server
(host) needs to have permissions set so that ODBC can connect to the
application that is being connected to. The application has to be told
to accept ODBC connections.

Once all of the above are met then ODBC will likely work fine.


-Jim