Connect Excel to MySQL 5.1
 
Connections to MySQL 5.1 can now be configured using the connection wizard in SQL*XL. Simply select MySQL as the database type and type the username and password. The database and server names are optional. SQL*XL will try some 8 different connections and simply pick one of the connections that was successful.
 
Other ways to connect to MySQL are through the SQL*XL ODBC connection screen. There is actually no need to setup a DSN in the control panel. Select the MyODBC driver from the drivers list, provide your username and password and a connection is made.
 
You can of course always make a DSN. This will be stored centrally on your computer in the ODBC applet in the control panel. To setup a DSN it is easiest to press the button to make a new connection in SQL*XL. Then select the Microsoft Data Link Properties Wizard. In the DLP wizard select the ODBC provider (driver), then build a new system DSN for MySQL.
 
I hope you agree that with the connection wizard it is all much easier to do!  
 
Support for MySQL 5.1 in the connection wizard is available from SQL*XL 4.3.12