Merging excel worksheets


Dear Excel Experts

I have 3 excel files (excel 97, xls) and the 1st has 3 columns like the
following:

BIBID | Author | Item Barcode | Location

and 2nd file has 2 columns like the following

ITEMID | BIBID

and the last file has 3 columns like the following

ITEMID | Title | Subject

I tried to combine these 3 files into 1 by going to Get External Data,
new query, thn i defined the new data source as microsoft excel driver.
It said this data source contains no visible table. Is there any other
method where i can join the 3 files so that i get Author | Item Barcode
| Location | Title | Subject in 1 excel work***, please advise!


Regards/Mike


--
bklim
------------------------------------------------------------------------
bklim's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24268
View this thread: http://www.excelforum.com/showthread.php?threadid=387937

.