Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

select certain column to .csv file Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 2:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 2:45 PM
Points: 4, Visits: 6
I have a database it is 50 gb with hundreds of columns
I would like to choose a certain column and convert the data in it to .csv or excel file
How can I do that I am very new to MSSQL
Thanks in advance
Post #1586144
Posted Wednesday, June 25, 2014 2:51 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 13,520, Visits: 11,313
* if the excel needs to be formatted, I would create a report in SSRS and export to Excel
* bcp
* SSIS
* Import/Export wizard




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1586146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse