SQL SERVER 2005 EXPORT UTILITY

Question

Post reply

SQL SERVER 2005 EXPORT UTILITY

bhanu.sharma

Newbie

Points: 7
More actions
February 20, 2008 at 10:01 pm

#378678

Hi ,
Please let me know how to export SQL SERVER 2005 table into a flat file .
Thanks..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Rumtata SSC-Addicted Points: 473 More actions · Answer 1

Hi,

take a look at the BCP (bcp.exe) utility...

HTH,

Karsten

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736255

February 21, 2008 at 9:58 am

#780744

You can also check the data export wizard.

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 3

Hi,

You can even use DTS/SSIS.

Thanks -- Vj

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

philliphiggins SSC Veteran Points: 255 More actions · Answer 4

Right click the database and choose "Tasks - Export Data". Choose "Next" then "Next" again. You will be in the "Destination" step. For a data destination, choose "Flat File" in the drop down. Enter a valid file name in the file chooser text box. Click "Next". Choose the "Copy data from one or more tables or views" radio option then click next again. Choose the table you want and follow the wizard to the end to create your flat file. Hope this helps.