Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- bklim ------------------------------------------------------------------------ bklim's Profile: http://www.excelforum.com/member.php...o&userid=24268 View this thread: http://www.excelforum.com/showthread...hreadid=387937 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel merging and automatic edit of worksheets | Excel Worksheet Functions | |||
Merging Excel Worksheets | Excel Discussion (Misc queries) | |||
merging 2 worksheets | Excel Discussion (Misc queries) | |||
Merging Worksheets in Excel | Excel Programming | |||
Merging Worksheets | Excel Programming |