EXCEL(VBA) How to pass an sql query value into a variable?

Question

I'm using MySQL and EXCEL(VBA) How can I pass an sql query value into a variable?

I have a variable Dim-ed:

Dim sqlVar As Variant

It's variant because I'm not sure which type I should use. I have set the sql query to the variable like this:

sqlVar = "SELECT datum FROM arfolyam ORDER BY datum ASC LIMIT 1 "

But like this, it stores the sql query, not the value of the query!

Any ideas?

Gulredy · Accepted Answer · 2012-08-30 10:41:13Z

1

...
Dim strSQL as String    
...
strSQL = "SELECT column FROM table ORDER BY column DESC LIMIT 1"
Set rs = cn.Execute(strSQL)   
variable1 = rs.Fields(0).Value

This way the sql query's value which is in this case is one cell, will be given to the variable1

answered Aug 30, 2012 at 10:41

Gulredy

1071 gold badge3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

EXCEL(VBA) How to pass an sql query value into a variable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related