• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • 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....

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
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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