How can I import data from a mysql database into excel

[Guest]

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

 

[Guest]

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.

 

[Guest]

I have a driver for mysql isntalled that I use for squirrel but do I use the
same one? If not how do I get the correct driver? Also the driver for
squirrel is not a .dll file it is a jar file. Is this a problem? Thanks in
advance.

 

[Guest]

You can check if you create a DSN to MySQL the following way:
- Open the tool "Data Sources (ODBC)" (normally in Start menu ->
Administrative Tools -> Data Sources (ODBC), you can also access through the
control panel -> Administrative Tools)
- It will open on the User DSN tab. Click the Add button there, and you
will be presented with a list of drivers.
- If you have the MySQL listed there, select it and fill the appropiate
information. If not listed, you may need to look for support on MySQL on
Windows, about how to set an ODBC connection.

If you could create the DSN, it will be available when you launch the Import
data wizard from Excel.

Miguel.