Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Connect Excel to MySQL 5.1 (Read 11458 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Connect Excel to MySQL 5.1
04.01.09 at 11:13:32
 
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
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
keokeo
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Re: Connect Excel to MySQL 5.1
Reply #1 - 17.06.09 at 11:59:32
 
Thanks for your posts. They are really very cool, very wonderful. Grin
simulationcredit
Back to top
 
« Last Edit: 17.06.09 at 11:59:57 by keokeo »  
Email   IP Logged
major2000
YaBB Newbies
*


I AM TESTING SQL*XL

Posts: 1
Re: Connect Excel to MySQL 5.1
Reply #2 - 09.04.11 at 14:34:31
 
Hi,
I recently download the trial software sql-xl.
I am wondering if a connection is possible on a live database on a website server. If yes how should we configure the connection.
Please respond ASAP
 
Thanks
Back to top
 
 

Still testing SQL*XL - Hope this will give the solution to my monthly problems.
Email mamboufils21   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Connect Excel to MySQL 5.1
Reply #3 - 09.04.11 at 14:50:17
 
Sure it is possible.  
You need to use the MySQL driver. You can download it from the MySQL website. Simply connect to the database (you can use the connection wizard in SQL*XL to help you out) and treat it as if it were a local database.
 
Let me know if you need further help.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1