Hi,
I am having problems with using aliases in a recordset based on excel range. The issue with a using recordsets while querying large data sets (above 65569 rows) was described in another thread http://www.excelforum.com/excel-prog...-with-sql.html where RS suggested using the follwing code 
Please Login or Register  to view this content.
and this works fine simple queries. But I want to build join query and use aliases and adding an alias at the and of the query just does not work e.g. 
Please Login or Register  to view this content.
will not work. It work though if I skip the range e.g. 
Please Login or Register  to view this content.
.

Can anyone help?

Thanks