Table Name = ColorTable
| ID | ColorSerial | ColorPart | ColorType |
Export From SQL Table to Text Delimted file
Cam some guide me on writing a stored procedure to export a table to a text delimited file step by step. I am going to make a table up. I want to export the entire below to text fdelimited file. Path is going to be C:\Temp\ColorTable.Text Can someone assist
Table Name = ColorTable
Table Name = ColorTable
David SmithPosted Mar 8, 2012, 10:13 AM
Lets say I have a Database call Named or called ColorDatabase and the table name ColorTable how to put this in the syntax below, I am struggling with the syntax below. Is it the local computer servername or the server the database is on.
BCP master..sysobjects out c:\sysobjects.txt -c -t, -T –S<servername>
Hermes CondezPosted Mar 8, 2012, 6:07 AM
Creating a simple CSV file.