connecting to MYSQL

I

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top