Results 1 to 1 of 1
12-31-12, 13:31 #1Registered User
- Join Date
- Dec 2012
Unanswered: Joining two worksheets in separate workbooks
I have two different excel files, and I have two ADODB connections to these files in my code.
I need to do a left join on a worksheet from one file with a worksheet from the other file.
How can I do it in one single SQL statement (which would normally be possible if both worksheets were from the same file = 1 connection)?
I understand I cannot supply both both connections to the objRS.Open line...
Is it even possible?