Connecting two excel documents

  • Thread starter Thread starter KT
  • Start date Start date
K

KT

If I have two separate spreadsheets in excel, with a few
overlapping shields, how do I connect them so I can search
both at the same time through Access?
I would really appreciate any help I could get!
 
You could link the 2 worksheets and then search them using a Union Query but
you must have the same number and type of fields to create a Union Query.

Or you could open them as recordsets and search them sequentially (eg using
DAO )
 
Back
Top