How to export delimited (tab, space, comman) file from query analyzer





How to export delimited (tab, space, comman) file from query analyzer Visual Management Studio (2005)

In the  Query menu choose Query options

1.  From Results Choose Text

2. Choose out format from drop down list

3.  Click OK.

4. In the query menu from  Result to choose Result to file

5.  Run your query it will ask you the file name  and by default it shows in save as type [Report files (*.rpt)]

6. Choose  All files (8.*) from save as type drop down.

7. Name your fiel as “myfil.csv” and click on save.




Tags: , ,

Comments are closed.