Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting a view using bcp

Status
Not open for further replies.
shep6

shep6

Programmer
May 4, 2001
38
0
0
GB
I'm pretty new to sqlserver....Does anyone know how to include the field headers when I export a view using bcp, I have managed to export the view (as a text file), but need to include the headers!

Can anyone help?

cheers



 
Sort by date Sort by votes
Hi,

Why dont you just copy the sql statement and paste it into a blank view ? Or am I missing somthing ?
 
Upvote 0 Downvote
Thanks Andy

As I said in my post I'm new to SqlServer!!!

I copied the sql from my view into the query screen, via the DTS wizard, and hey it works!

thanks again
 
Upvote 0 Downvote
Glad to help Mate

I did not mean to sound condisending by the way :eek:)

Andy
 
Upvote 0 Downvote
No you didn't - need all the help I can get!!! s-)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
117
Mike Lewis
Mike Lewis
TheBugSlayer
  • Locked
  • Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's 1
Replies
7
Views
197
Nick_Evans1
Nick_Evans1
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
85
Auguy
Auguy
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
124
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
79
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top