开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜