connecting to MYSQL

[irene c]

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.

 

[Bob Phillips]

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.

--
HTH

Bob Phillips

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