How to dump SQL Table into csv or txt 1

[amardesai2005]

How do i dump sql Table into csv or txt ?

Anyone can please help me out to write sql which dump sql table data into csv.

I have table name called productnames
Thanks
AD

 

[mrdenny]

Use BCP from a command prompt.

bcp productnames out "c:\files.txt" -S {ServerName}  -T  -t "," -c

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[amardesai2005]

When i try to run this in query analyzer. I am getting syntax error.

bcp productnames out "c:\files.txt" -S {NS_EDB_D3} -T -t "," -c


could you please look at following topic which i have posted.

Improve perfomance-Transfer data one table to another

Please help me out.

AD

 

[MDXer]

did you do the bcp from a command window or from query analyzer? what was the syntax error? Also I believe you do not nee the {} for the server name

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[mrdenny]

This command should be run from a command window, not from Query Analyzer. Remove the {} from the servername as MDXer said.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[SQLDenis]

You could run it from QA like this (assuming you can execute xp_cmdshell )

This will work for the publisher table in the Pubs DB

exec master..xp_cmdshell 'bcp pubs.dbo.publishers out "c:\files.txt" -S {YourServerNameHere} -T -t "," -c'

http://sqlservercode.blogspot.com/