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
精彩评论