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 5 of 7

by Krishnamoorthy D
Feedback

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

Article Contents:

Import from a file to a table/view

I have tested with pubs database.

Listing 5

Exec IMPEXPFROMDB ‘C:\IMP\Import.txt’, ‘IN, ‘Employee’

The file should exist in the server in the valid directory. The file should contain the default format as tab space for field separator and new line for row terminator.

« (Page 4)

View Entire Article

(Page 6) »

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