View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default How can I import data from a mysql database into excel

Excel can use ODBC connections, check if you have the ODBC driver for MySQL
installed, and launch the import data wizard. At some point you will be able
to select/configure the ODBC connection to your database.
If you want to be sure, configure and test first the connection in the
Windows Administrative Tool for ODBC, and it will be available for the wizard.
I don't have MySQL installed, so I cannot give you the details on how to
configure it.

Hope this helps,
Miguel.

"Tina" wrote:

I am new to am trying to find a way to import data from a mysql database to
excel. I can't figure out what driver to use. The mysql server is on the
local pc. Any help you can provide would be great.
Thanks