Re: VBA connection to MySQL
Assuming your input variable is In cell A1 on sheet1
add this line before the strSQL line:
xxx = WorkSheets("Sheet1").Range("A1").value
and change your exisitng line as follows
strSQL = "select FIELD1, FIELD2, FIELD3 from DATABASE1.TABLE1 where FIELD4='" & xxx & "' order by date;"
hope this helps,
B
Subject
Written By
Posted
February 20, 2009 05:37AM
February 20, 2009 08:43AM
Re: VBA connection to MySQL
February 28, 2009 08:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.