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

H = integer of 1 to 300. This seems simple enough but I am having a rough time of it.

Thanks in advance, Mark

 

[SkipVought]

Mark,

Since this is VBA, please post in the VBA forum707

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}