Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

SQL 2008 R2; Have a query copy to Excel

Is there a way to have the query run then copy to Excel on the local drive?

I am familiar with Visual Fox Pro doing this and was wondering if possible in SQL Server 2008 R2.

We are converting to use SQL Server now....

Thanks
0
jaymz69
Asked:
jaymz69
1 Solution
 
ValentinoVBI ConsultantCommented:
Should be possible through the OPENDATASOURCE() function, have a look here for a similar Q: http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_26228670.html
0
 
Alpesh PatelAssistant ConsultantCommented:
Please change the Result window to File and specify the file name. So, when you execute the Query result will go directly to file.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now