Chaplain Doug wrote:
Dear Sabastien:

Actually I want to populate a record set and do some manipulations and
calculations on the data. Hence, the built-in "external data"
capability of Excel will not suffice. Can you suggest some code that
would use the query and place the results in a record set that I
could then process through? Thanks for any help. God bless.


Try here

http://www.dicks-blog.com/archives/2...ordset-basics/


--
Dick Kusleika
MVP - Excel
Daily Dose of Excel
http://www.dicks-blog.com