Query 2 excel files with ADO

[Kained]

Is it possible to query two excel files with ADO?

By this I mean, using two separate excel files (as tables, each with same
UIDs) and being able to perform an INNER JOIN on them?

I understand alternatives are to create two connections and loop through the
second with various methods, but am really after a sleeker solution using a
single query.

Any pointers are most appreciated.

 

[Joel]

using ADO method is basically like opening up the excel file as access
databases and performing the operation using access. If you can do it with
access then you can write a macro to perform the same operation.

In reality the file structure of all microsoft products are the same. A
file consists of either tables, pictures, documents, .... An excel worksheet
is eactly the same as access table. That is why you can use the ADO method
either on the access table or the excel worksheet.

I usually record a macro in Access and then move the recorded macro in tho
excel when I'm experimenting with new idea.

 

[Kained]

I usually record a macro in Access

Joel, so i could potentially make them linked tables and then record a macro?

 

[Joel]

I haven't tried it, but it should work.

Joel, so i could potentially make them linked tables and then record a macro?

 

[Kained]

thanks, but now am confused... sorry to sound like a complete idiot, how
would you 'record' a macro? The functionality (akin to excel) is not
available, not in Access 2002 am using anyway.

 

[Joel]

I forgot access doesn't havve this feature. try this webpage

http://office.microsoft.com/en-us/marketplace/EM011329971033.aspx