How to assign SQL query resluts to a variable

[beetlebailey]

I have a simple Excel VBA query as follows:

SQL="Select Hour1 from vpd where line=502"

Now how do get the results of Hour1 assigned to a variable H

This seems simple enough but I am having a rough time of it.

Thanks in advance, Mark

 

[checkai]

not sure this is the right forum for this....

if you were using a sql server db then you'd do this

declare @hr as int;
select @hr = Hour1 from vpd where line=502

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."