PDA

View Full Version : Copy "My Sql" Query from worksheet and connect to MY Sql and get results



vradhak7
11-01-2015, 05:24 PM
Hello VBA Experts,
I was wondering even if this possible!
I have a workbook in which a worksheet named "Practical" has sql query from Rows C1:J1 . I would like to create a button using VBA which will access my "MySQL" and copy/paste the query in it, run and get the output to Worksheet "Result" in the workbook "Test_Application".

My Server name is OPStest
User name is ops_test
Password is opstest

I have not created an ODBC Connection yet. Your expertise and guidance would be really helpful and appreciated.Thank you!