View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kained[_2_] Kained[_2_] is offline
external usenet poster
 
Posts: 5
Default Query 2 excel files with ADO

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.