Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Features Connecting

Buy now

Download now

SQL*XL online help

 

SQL*XL: Excel MySQL ODBC Connection

SQL*XL: Excel MySQL ODBC Connection

SQL*XL
home

To connect to MySQL using the ODBC driver (Open DataBase Connectivity) please follow the procedure below:

If your MySQL database is running on a web server, connect to the internet first.
Start Excel
Open the Connection dialog: SQL*XL | Connect...
Start the Data Link Properties wizard
 

Data Link Properties

 
Choose the Provider Microsoft OLE DB Provider for ODBC Drivers.
Select your data source name (DSN) from the list.
 

 
If there is no DSN for your database in the list use the Refresh button.
If it is still not in the list you may need to create a new DSN using the ODBC Data Source Administrator

If you do not have an ODBC driver for MySQL then download a free copy from:
http://www.mysql.com/downloads/api-myodbc.html
After you choose a data source name you, enter the user name and password.
Always use the Test Connection button before you continue
 

After connecting to the database once you can reconnect by selecting the connection from the Connection History list and typing the Password.


See also:

SQL*XL ribbon in Excel