Connection between Excel and MySql Workbench

Hey, guys!

I've been having a tough time in the last couple days trying to connect an excel file with SQL. I'm using MySQL Workbench and WAMPSERVER and I want to send my queries from excel to the DB on a local host (no need of phpadmin or something like that).

At first, I tried to make a connection directly trough VBA, using codes I found on the internet. Sadly, all my attempts failed.

Later on, I decided to use the Excel automatic option. This means I'm trying to access the SQL Server this way: Click on Data, From Other Sources, From SQL Server.

I've installed like a thousand different plug-ins and I've followed different instructions from an uncountable number of different threads and forums I've found on the internet, but nothing seems to work or I just don't correctly understand how to do it.

Does anybody have an easy, step by step webpage link where the damn connection is explained? Everytime I try to do it I get the following error message:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Thanks!

Ps: is it fine to post this thread on this particular part of the Forum?

Depends on your needs I guess. Have you looked at an add-in?
http://www.mysql.com/why-mysql/windows/excel/

Can't imagine how grateful I am! You wouldn't imagine how many weird stuff I found around that didn't actually worked!

Now, is there anyway I can send querys and statements from the excel file to mysql workbench?

Yep, can't get to see/import my queries

IF you want more control, ADO is the way to go. The key part to doing that is the connection string. http://www.connectionstrings.com/mysql/

It may be late tomorrow before I get back to this with my example of ADO code using mysql.

Can you copy me the Example you say you have?

Thanks again!

As Norie said, it does make a difference in the code whether it is MySQL or SQL Server. See the website that I listed post #5 for the two connection strings.

Of course there are many ADO examples on the net. Here is the MySQL example that I promised. See the link where I posted it for more details.

Please Login or Register  to view this content.