I just started a thread in the db forum on whether it's possible to set left joins in excel's 'import external data' query tool and then it occurred to me that the office dev forum might be a better place.

I'd really apreciate it if anyone who knows much about this tool could have a look and post in the other thread (just to prevent duplicate information).

Thanks