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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging excel worksheets
I am not sure why your data query told you it couldn't find the data - but to
make sure you can do it try naming the ranges and remember to save the workbooks. When you specify the Excel data source and give the file name it should let you choose either worksheets or named ranges; specify the named ranges and you should be able to do it. If all 3 tables are put first in the same workbook (Copy the sheets into a master workbook and save it), I think you should even be able to bring all 3 tables into your query and link them inside MSQuery. -- - K Dales "bklim" wrote: 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 |
Reply |
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 |