by Jason Monroe (4 Submissions)
Category: OLE/COM/DCOM/Active-X
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(7 Votes)
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.
Inputs
See documentation (readme.txt)
VBcoders
