# Bulk Import/Export overview

Derby provides import and export system procedures that you can use to import and export data in delimited data file format.

- Use export procedures to write data from a database to one or more files that are stored outside of the database. You can use a procedure to export data from a table into a file or export data from a SELECT statement result into a file.
- Use import procedures to import data from a file into a table. If the target table already contains data, you can replace or append to the existing data.

You can perform an Import or Export operation from `ij` or from within an SQL statement.

- Options for running the import and export procedures
- Bulk import/export requirements and considerations

Parent topic: Using the bulk import and export procedures
Related concepts
Bulk import and export