Hi:

I'm currently using an embedded MS Query to populate a temporary
spreadsheet, then using the resulting rows to populate other spreadsheets,
then removing the temp sheet. I would rather use an ADO recordset to
accomplish the same thing and not have to manipulate a temp sheet.

Problem: The embedded query links two separate Access databases and uses
tables from each in a single Join SQL statement. I've not been able to set
this up using ADO connections, and have found nothing on the forum addressing
this specific situation. Can it be done?

Thanks in advance!

Greg