microsoft query add-in

[diane]

I have just installed the Microsoft Query add-in to
Excel...can anyone tell me if this is the exact query that
Access uses, or are there differences in them.

Thanks
diane :?:

 

[Terence]

Query kind of looks like Access, but it not nearly as
powerful. It has several limitations. For example, what
I think is the biggest hinderance, is the inability to do
Outer Joins in Query. I do use Query, but mainly to bring
something in from Access.