Published:
07 Aug 2006
|
Abstract
In this article you will learn how to import and export data using Bulk Copy Program utility. |
 |
by Krishnamoorthy D
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
35321/
75
|
|
|
|
| Introduction |
I dedicate this article to my mother Prajavathi.
This article shows how to import and export from a File to a
table/view and vice versa using SQL Server 2000 Bulk Copy Program (BCP)
utility. BCP is the fastest and easiest way to import and export from a file. This
article will be very useful to a developer by simply plugging in this stored
procedure wherever it is needed or to execute it to get the result. I have
used BCP for import/ export from a text file and a DOS shell command to execute
the BCP command.
|
|
|
|
User Comments
Title:
Chido one
Name:
Mario
Date:
2007-04-27 1:35:29 PM
Comment:
I read many webs, but this is easy.
Tks a lot , a lot, a lot.
|
Title:
BCP Programming
Name:
sivakumar R
Date:
2006-12-26 7:56:35 AM
Comment:
Fine , Thanks a lot
|
Title:
Example is wrong
Name:
Faiz
Date:
2006-12-11 10:19:41 PM
Comment:
Following Example wromg .
Example : if you like to copy from differant server
also SP displaying 2 times for table name.
Thanks
|
Title:
Bulk article
Name:
Radhakanta
Date:
2006-11-14 3:09:37 AM
Comment:
nice article and is very useful.
|
Title:
BCP Article
Name:
Siva Kumari K
Date:
2006-09-13 4:07:27 AM
Comment:
Very Usefull Article, Really i wasted lot time before, thank u very much
|
Title:
BCP UTILITY
Name:
BALAJI SINGH
Date:
2006-08-15 11:45:25 AM
Comment:
Bulk made easy and understandable, with this simple article.
Thanks.
|
Title:
Now we need a BCP Format article
Name:
Darren Bates
Date:
2006-08-11 1:18:25 PM
Comment:
Thanks for the overview. What I'm trying to work with is the format file to define the data import from a text (or native) file into a table where the schema doesn't exactly match
|
Title:
Good
Name:
Manohar
Date:
2006-08-08 2:58:19 AM
Comment:
Good
|
Title:
BCP Article
Name:
G.Balasubramanian
Date:
2006-08-08 12:40:03 AM
Comment:
Very usefull, automates lot of process, thanks..
|
Title:
BCP Article
Name:
Aravind Kumar
Date:
2006-08-08 12:21:20 AM
Comment:
Very useful article. This will automate lot of process and save the worktime.
Aravind
|
Title:
Bulk article
Name:
Esmeralda Pita
Date:
2006-08-07 12:05:39 PM
Comment:
Very usufull, thanks
|
|
|
|
|
|
