Msquery and join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thank You.

But I don't know your explications wery well.

It's possible to have un example ?

Thierry

"Carlos Antenna" a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

msquery in Excel 2007 1
msquery prompt for password 3
Trying to run a MSQuery from Excel as a Scheduled Task 1
MSQuery error:Cross Join option is not enabled. 1
Problems Query with MSQuery 1
MSQuery link to same file 1
Outer Joins msquery vs access 1
MSQuery Parameters and Group/Summation URGENT! 3

Back
Top