• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1106
  • Last Modified:

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?
0
dkcoop03
Asked:
dkcoop03
  • 5
  • 2
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now