| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query Joins
I use MS Query in Excel often. I am trying, however, to change the Join and
am given 3 options when I double click on the join between two tables. When I do that, the botton 2 options are grayed out (I can't create inner/outer joins). WHy is that and how can I get them "un-grayed" so I can change the join type? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS Query Joins
MS query does not like outer joins. It will only allow 1 and it will also
complain if you have multiple tables where 1 is outer joined. I personally use a VBA routine connecting via ODBC when the need arises. You need to be able to write the SQL from scratch to do that... Not sure if this helps... -- HTH... Jim Thomlinson "bmmulligan1" wrote: I use MS Query in Excel often. I am trying, however, to change the Join and am given 3 options when I double click on the join between two tables. When I do that, the botton 2 options are grayed out (I can't create inner/outer joins). WHy is that and how can I get them "un-grayed" so I can change the join type? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel query via ODBC, left joins on multiple tables | Excel Discussion (Misc queries) | |||
| MS SQL Server Joins Concept | Excel Worksheet Functions | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Joins semicolon seperated text in two cells | Excel Discussion (Misc queries) | |||
| Outer Joins | Excel Discussion (Misc queries) | |||
Linear Mode
