|
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 worksheet, please advise!
Regards/Mike
|