connecting to MYSQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

irene c - 30 Jan 2007 03:55 GMT

hi. I'm new in Excel. I have 2 questions.

1. In order to connect Excel with a MYSQL database, is it correct that I
have to install MYSQL ODBC driver into my Excel?
2. Is it possible to retrieve data directly from MYSQL database without
having to extract the data into an excel sheet?

Thank you very much for your help.

Reply to this Message

Bob Phillips - 30 Jan 2007 09:43 GMT

You have to install a MySQL driver, be that ODBC or OLEDB, but not into
Excel. You should be able to get such a driver from MySQL.

When you query the database, you could use ADO to do the query, and return
the results into a recordset within the code. That recordset could be
manipulated directly, copied to an array, or to a worksheet. Multiple
choices.

Signature

HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> hi. I'm new in Excel. I have 2 questions.
>
[quoted text clipped - 4 lines]
>
> Thank you very much for your help.

Reply to this Message