is it possible to write a query that will export my reuslts to an excel
spreadsheet with tsql?Try DTS packages
--
Thanks & Rate the Postings.
-Ravi-
"mcnewsxp" wrote:
> is it possible to write a query that will export my reuslts to an excel
> spreadsheet with tsql?
>
>|||>
> Try DTS packages
> --
not what i was looking for, but thanks.|||If you click in your Results window in Query Analyser (QA) and do 'Save As'
you can save the results as a file, and the open it in Excel.
Alternately you can use bcp and the 'queryout' option if you need a special
format. This is a big topic so google bcp and queryout.
Finally, again in QA, you can customise your results in the 'Tools' and
'Options' menu:
General Tab
Set a default Result file directory
Results Tab
Change Results output format from 'Results to Text' to 'Results to File'
Change the Result file extension from .rpt to .xls
Let me know how you get on.
Damien
"mcnewsxp" wrote:
> is it possible to write a query that will export my reuslts to an excel
> spreadsheet with tsql?
>
>|||Look into makewebtask. It is real easy to write a query that sends directly
to Excel as long as you only have 1 tab.
"mcnewsxp" wrote:
> is it possible to write a query that will export my reuslts to an excel
> spreadsheet with tsql?
>
>
No comments:
Post a Comment