Hello ;
First time to this site , was searching on web for help on a Excel/SQL/MySQL problem I'm having and this site pop'd up in the search. .. So I'm hoping you nice people can help me
I've been experimenting with limited success on using SQL to transfer Data Between access and Excel through ADO. By using VBA in Excel.
I've just installed MySQL server and would like a little help on the Excel VBA code to get these two talking to each other.
Example:
MYSQL db name= Resources, Table = Assignments , Field = Owner
How do I :
- Set up an ADO conection using Excel's VBA and download all informtion where the Owner = "John" !
Help much appreciated Thx
First time to this site , was searching on web for help on a Excel/SQL/MySQL problem I'm having and this site pop'd up in the search. .. So I'm hoping you nice people can help me
I've been experimenting with limited success on using SQL to transfer Data Between access and Excel through ADO. By using VBA in Excel.
I've just installed MySQL server and would like a little help on the Excel VBA code to get these two talking to each other.
Example:
MYSQL db name= Resources, Table = Assignments , Field = Owner
How do I :
- Set up an ADO conection using Excel's VBA and download all informtion where the Owner = "John" !
Help much appreciated Thx
MySQL > Excel using SQL in EXcel's VBA