Wednesday, February 15, 2012

Export result to the Excel

Hi,

I am a new in SQL Server.
I have a question.

I create the table called "tbl1"
I create a query called "qry1", this query retrieve the data from the "tbl1".

after running the query, and then convert the result to the Excel.

How can I do that?
Please let me know, thanks a lot. Thanks.Other than copy/paste?

Well, you can use DTS (Data Transformatin Services) to export data. Is this a one-time export, or does it need to be part of a scheduled process?|||or save the column delimited results as a text file and import to excel as fixed width text file|||Is this from withing Access?

No comments:

Post a Comment