Chapter 3: Using bcp to Transfer Data to and from Adaptive Server

This chapter explains how to use the bulk copy utility, bcp, to move data between Adaptive Server and an operating system file.

bcp provides a convenient, high-speed method for transferring data between a database table or view and an operating system file. bcp can read or write files in a wide variety of formats. When copying in from a file, bcp inserts data into an existing database table; when copying out to a file, bcp overwrites any previous contents of the file.

For a detailed description of bcp syntax, see bcp.