Connecting two excel documents

K

KT

I am new to the computer world, and this might be a simple
question...but!
If I have two excel documents with different information.
Both have overlapping fields, and want to be able to
search both at the same time, how do I connect them in
Access?
Thanks
 
D

Douglas J. Steele

Try linking to them through File | Get External Data | Link Tables... on the
Menu bar. Once you've linked the two documents, they'll appear as tables to
Access, so that you'll be able to write queries against them.
 
Top