Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 saving results from query editor

Author  Topic 

atiqraza
Starting Member

11 Posts

Posted - 2009-01-21 : 15:18:23
I am trying to export tables from my sql server 2005 database. the problem with .csv files is that an address table already has comma's in some of its fields. is there any way i can save the files in another format, because in the query editor it only gives the option to save as a .csv file. tilda delimiter or even text files.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-21 : 15:21:15
Use bcp/SSIS/DTS to export the data to a file and specify a different field terminator than comma. Choose a field terminator that doesn't exist in your data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -