Import CSV File(Tables Menu)

DBExplorer can import data directly from a delimited or CSV file. Upon selection of this function, a form is displayed and the import specifications may be defined.

Import Dialog Items

Import into table

The name of the currently selected table that is the destination for the data imported.

Import file

The name of the delimited file to be imported. A browse button is provided to allow file selection.

Initial records to skip

The number of initial records to skip during the import process.

Inserts per transaction

The database inserts are batched into a transaction during the import process for improved performance. Adjusting this value from its default of zero (0) will decrease performance but offer some protection in the event of a failure.

Field delimiter

A single character that denotes the end of a field within each record.

Drop existing rows

Allows any existing data to be first deleted.

The input fields are quoted

Indicates that quotes surround each field within the record.

File resides on the client

If running under client server, allows the import file to be opened on the client rather than the server.

Log SQL inserts

This option causes the individual insert statements to be logged to the message window. Setting this option will degrade the performance of the import.

Columns

The name, starting position, and length of the columns to be imported. Columns may be excluded by clearing the check box on the appropriate line.

Progress

The progress section shows the record count and a progress bar. A stop button allows the import to be aborted.