Ryan, you can use a DTS job to export into several formats.





"ryan"
<mssqldba-ezmlmsh
ield-x23785170.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
03/28/2007 01:57
PM Subject
Exporting Data










Hi all -

Please excuse my ignorance. I am very new to this db stuff and obviously
I don't know what I am doing, but I am glad to have found this list
because I have learned a lot from just lurking over the posts.



I have a question I am hoping someone can either help me with or tell me
it isn't possible. I've done a bit of searching and think the answer
will be the later, but here it goes:



Is there a way to write a query and have it export the result to a csv
file (or something similar)? I am able to do this with no problems in
MySQL using 'into outfile' - but I can't seem to find a way with MSSQL
2000.



Any ideas/suggestions?



Thanks,

Ryan



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page