Connecting two excel documents

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!
 
D

Doug Bell

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 )
 

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

Integrating information from Word to Excel (not mail merge) 1
Embed the same Excel multiple times 0
Need Help with Macro Security 1
Word VBA - Want to test if Full Name is NOT Present in document 0
A couple questions BEFORE using Office 365 0
Excel does not accept text format! 0
Update several ppt documents from a single excel file 0
Finding asymptote equation and how to draw them in excel 0

Top