|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Text Qualifier in a CSV file from results in SQL Server 2k5 Man. SWhen I save my results of a query in SQL Server 2k5 Management Studio, I can
save it as a csv file. I have found where I can change the delimiter, but I can't find a place to put in a text qualifier. For example, I want the text to appear with Double-Quotes around it. Where can I configure this setting? For the life of me I can't find it... Thanks in advance, Greg Greg Toronto (GregToro***@discussions.microsoft.com) writes:
> When I save my results of a query in SQL Server 2k5 Management Studio, I I would guess the Export Wizard is what you should try. Or copy and> can save it as a csv file. I have found where I can change the > delimiter, but I can't find a place to put in a text qualifier. For > example, I want the text to appear with Double-Quotes around it. > > Where can I configure this setting? For the life of me I can't find it... past into Excel and work from there. Notice that Mgmt Studio has a nifty option that permits you to include the grid header when you copy the grid. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |
|||||||||||||||||||||||