Msquery and join

I French, so Sorry for my english.

I use Excel 2002 (or 2003) and I want to join 2 files dbase.
Under MSQUERY when I want to join this 2 files, in the 3 options, only the 1
is possible.

Why ?

Thank You.

Thierry

I have this same problem frequently.
I don't know why it works the way it does, but I have an alternate solution.

Make two separate querys on two sheets.
Then use the vlookup function on one of the sheets to get data from the
other sheet.
--
Carlos

"titi" <titi@discussions.microsoft.com> wrote in message
news:D75B5662-6D71-48AC-A1F5-C0230E109AF1@microsoft.com...
>I French, so Sorry for my english.
>
> I use Excel 2002 (or 2003) and I want to join 2 files dbase.
> Under MSQUERY when I want to join this 2 files, in the 3 options, only the
> 1
> is possible.
>
> Why ?
>
> Thank You.
>
> Thierry

Thank You.

But I don't know your explications wery well.

It's possible to have un example ?

Thierry

"Carlos Antenna" a écrit :

> I have this same problem frequently.
> I don't know why it works the way it does, but I have an alternate solution.
>
> Make two separate querys on two sheets.
> Then use the vlookup function on one of the sheets to get data from the
> other sheet.
> --
> Carlos
>
> "titi" <titi@discussions.microsoft.com> wrote in message
> news:D75B5662-6D71-48AC-A1F5-C0230E109AF1@microsoft.com...
> >I French, so Sorry for my english.
> >
> > I use Excel 2002 (or 2003) and I want to join 2 files dbase.
> > Under MSQUERY when I want to join this 2 files, in the 3 options, only the
> > 1
> > is possible.
> >
> > Why ?
> >
> > Thank You.
> >
> > Thierry
>
>
>