Thread: 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

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
>
>