Bulk Copy to SQL Server Made Easy

By | 2002-06-01

BCP is a method to transfer large amounts of data from a flat file into SQL Server VERY quickly. BCP is a functionality of the low-level DBLib environment. Unfortunately the modern data components (ADO, DAO, RDO) don’t support bulk copy.


The only way to get to BCP in the past was to either use the BCP.exe tool shipped with SQL Server, or to write some serious low level BCP type stuff.



I wrote slpBCP.dll as a wrapper for VBSQL.ocx and DBLib. It will allow you the developer to reference the DLL in your project, Create a reference to the object, set a few properties, call a routine… and bulk copy data into your SQL server.

Original Author: Jason Monroe

Inputs

See documentation (readme.txt)

Attachments

FileUploadedSize
CODE_UPLOAD28601142000.zip9/3/2020 3:45:00 PM19990
Author: dwirch

Derek Wirch is a seasoned IT professional with an impressive career dating back to 1986. He brings a wealth of knowledge and hands-on experience that is invaluable to those embarking on their journey in the tech industry.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.