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

I have SQL Server 2005 Management Studio Express installed on my machine.  I need to export a table in our DB to CSV format.  How can I do this?
dkcoop03Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Cvijo123Connect With a Mentor Commented:
or look at this solution .. same using BCP but inside SP

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22613323.html
0
 
Cvijo123Commented:
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.
0
 
dkcoop03Author Commented:
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.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Cvijo123Commented:
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 )

0
 
dkcoop03Author Commented:
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.
0
 
Cvijo123Commented:
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>

Open in new window

0
 
Cvijo123Commented:

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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.