SQL Server Driver Extensions - Bulk Copy Functions

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Open Database Connectivity (ODBC) is a Microsoft Win32 application programming interface used by applications to access data in ODBC data sources. The SQL Server Native Client ODBC driver reference does not document all of the ODBC function calls. Only those functions that have driver-specific parameters or behaviors when used with the SQL Server Native Client ODBC driver are discussed.

The SQL Server Native Client ODBC driver complies with the ODBC 3.51 specification. For a comprehensive reference of ODBC 3.51, download the Microsoft Data Access Components SDK from the Data Access and Storage Developer Center, or view the ODBC Programmer's Reference online.

The SQL Server-specific bulk-copy API extension of the SQL Server Native Client ODBC driver allows client applications to rapidly add data rows to, or extract data rows from, a SQL Server table. When using SQL Server Native Client, you can reference the bulk copy functions (BCP) in SQLNCLI11.LIB and SQLNCLI.H.

An application that uses BCP API function calls should link with the library (.lib) that shipped with the driver (.dll) used by the application. A BCP application should not link with more than one driver library.

In This Section

• bcp_batch

• bcp_bind

• bcp_colfmt

• bcp_collen

• bcp_colptr

• bcp_columns

• bcp_control

• bcp_done

• bcp_exec

• bcp_getcolfmt

• bcp_gettypename

• bcp_init

• bcp_moretext

• bcp_readfmt

• bcp_sendrow

• bcp_setbulkmode

• bcp_setcolfmt

• bcp_writefmt

See Also

SQL Server Driver Extensions
Performing Bulk Copy Operations (ODBC)