Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel query via ODBC, left joins on multiple tables
Using Excel 2003 and Windows XP
In Excel, in a query built in Microsoft Query/ODBC, I bring in information from about 7 tables from a SQL Server 2005 database. Now I want to add an 8th table connected to one of the other tables, have all the records that currently appear still appear and, if a result is present in the 8th table, display it. If no record is present in the 8th table, leave the cell blank. Normally, I would do this with a left join. However, because of the number of tables, MS Query says I can't do that. Now, I go to another program, SQL Excel, which doesn't complain when I put the left join statement in but still only returns records IF THERE IS A RECORD PRESENT IN THE 8th TABLE. Is this a "feature" of ODBC? Is there any way I can get around it using something built into Excel, using something free or using something built into Windows? Or do I have to pay for something to get it done? Thanks, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
odbc error on Excel query into database | Excel Discussion (Misc queries) | |||
how to access databases from excel using ms query and odbc? | Excel Discussion (Misc queries) | |||
msquery odbc -- excel repeats query on return | Excel Discussion (Misc queries) | |||
Excel query via ODBC cuts values | Excel Discussion (Misc queries) | |||
Multiple ODBC Database lik in one MSQUERY query | Excel Discussion (Misc queries) |