Working with Bulk Copy Program Utility
page 1 of 7
Published: 07 Aug 2006
Unedited - Community Contributed
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): 36339/ 174

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.


View Entire Article

User Comments

Title: Chido one   
Name: Mario
Date: 4/27/2007 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: 12/26/2006 7:56:35 AM
Comment:
Fine , Thanks a lot
Title: Example is wrong   
Name: Faiz
Date: 12/11/2006 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: 11/14/2006 3:09:37 AM
Comment:
nice article and is very useful.
Title: BCP Article   
Name: Siva Kumari K
Date: 9/13/2006 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: 8/15/2006 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: 8/11/2006 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: 8/8/2006 2:58:19 AM
Comment:
Good
Title: BCP Article   
Name: G.Balasubramanian
Date: 8/8/2006 12:40:03 AM
Comment:
Very usefull, automates lot of process, thanks..
Title: BCP Article   
Name: Aravind Kumar
Date: 8/8/2006 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: 8/7/2006 12:05:39 PM
Comment:
Very usufull, thanks






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 10/21/2014 1:22:07 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search