Join statements using ADO across separate Worksheets

[gimme_this_gimme_that]

Is it possible to join worksheets based upon a common column/key over
separate worksheets in the same workbook?

Does anyone have an example query?

Thanks.

 

[Bob Phillips]

If you set the ranges on the separate worksheets as named ranges
(Insert>Name>Define...), you can use standard SQL using the names as the
tables.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[gimme_this_gimme_that]

How do I define colmns - say I want to join on columns 1 and 2 of
Sheet1 and 2 and 3 of Sheet2?

Do I need a named range for the columns too?

Thanks.

 

[Bob Phillips]

Yes, but if you use dynamic range names, it will only extend as far as
necessary.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)