[RESOLVED] Write Query Loop on Excel worksheet in VBA module

[todd.kauffman]

Is it possible to set up and write SQL query on a worksheet? loop thru the record set and insert data onto another worksheet in the same file. If so, please show me a sample snippet on how to set it up in the VBA modules.