Working with Bulk Copy Program Utility: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Working with Bulk Copy Program Utility

page 4 of 7

by Krishnamoorthy D
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 33292/ 49

Article Contents:

Export from a file to a table/view

I have tested with pubs database using the table name Employee.

Listing 4

Exec IMPEXPFROMDB ‘C:\EXP\export.txt’, ‘OUT’, ‘Employee’

A file will be created under EXP directory in the server as export.txt in which the data will be copied. The file will be created in the server (where Sqlserver runs) not in the client.

« (Page 3)

View Entire Article

(Page 5) »

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