There is no problem doing a JOIN in Excel in SQL run on sheet ranges.
Look at this NG thread:
http://shorterlink.com/?H5CZPS

RBS

"urlwolf" wrote in message
oups.com...
Hi,

First, I must say that I'm not a VBA programmer and never used excel
much till now. I always wrote R code for manipulating data, but I have
come to believe that excel could save me time when I learned about
things like pivot tables recently.

The one thing that I thought was out of reach for excel was the JOIN()
operation (also called merge() in R)... but then I found this:
http://www.digdb.com/excel_add_ins/j..._tables_lists/

Which works very well. However, the price for the package is a bit
steep for me (an occasional user), and that is the only function I can
see myself using... so that takes me here. Do you know of any freely
available code that implements the JOIN operation for excel (2007 in
my case)?

Thanks!