开发者

Sql Query into excel

开发者 https://www.devze.com 2023-01-11 23:07 出处:网络
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 m

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

精彩评论

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

关注公众号