Sql Query into excel

I have a sql query that pulls in form multiple tables, how can I run that query to i开发者_StackOverflowmport into an excel sheet?

I presume that's 'from multiple tables'. In Excel got to the Data menu > Get External Data > From Other Sources > From Microsoft Query and open an ODBC connect. If you can't get the query right in Microsoft Query declare it as a View in your Database and of course you need an ODBC connection to the database

Not knowning your toolset, or even DB Platform, here's a guess.

http://www.mssqltips.com/tip.asp?tip=1202