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 )
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Microsoft Works to Microsoft Office 6
"Analyze with Excel" - AccXP and Acc 2003 2
Is it possible to dedupe two excel lists? 1
Exporting Data from Access To Excel 10
Calculating Overlaps 3
Importing unique records from excel into access 2
Excel Import External Data by Date Automatically 0

Back
Top