I have SQL Server 2005 Management Studio Express and need to export a table to CSV. How can I Do this?

Position yourself at your database in Managment studio then right click on database name then Tasks -> Export data

after that should be simple just follow wizard and u are done.

Management Studio Express does not have the Export data option on the Tasks menu.  I was wondering if there was another way to do it.

do you mybe have bcp.exe file ?
(located whre u installed your SQL Server .. usually in
C:\Program Files\Microsoft SQL Server\90\Tools\BinnC:\Program Files\Microsoft SQL Server\90\Tools\Binn )

I do have the bcp.exe file but the database where the table resides is on a different server.  How, using BCP, do I specify a server?  I use Windows authentication to connect to the DB in Mgmt Studio Express, but I haven't found any syntax that tells me how to specify a remote server in bcp.

should be same way u do it in management studio (ip or name)

BCP master..sysobjects out c:\sysobjects.txt -c -t; -T S<servername>

Select allOpen in new window

btw. one time i found this article to export data for excel file.

From excel u can do anything

http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx