Feature TourFeature Tour

Table Data Import

Previous Next

The import feature reads CSV files containing data organized as rows of columns with separator characters between them, and also Excel spreadsheet files. The data can be imported to a new table created based on the data in the file.


The file viewer show a CSV file as it looks on disk. This is useful to check what
delimiters are being used, quotes, column header, etc.
Raw File Viewer

The import feature tries to auto detect what column separators being used in a CSV file. This
can be manually overidden along with settings to control if text data is enclosed
in quotes, if empty rows should be ignored and if there is a column header row.
Data Delimiters and File Configuration

Data types are automatically recognized when the file is loaded. To change this
click the first row cell and choose the appropriate type from the list.
Data Type Setup

Columns in the file are automatically mapped to columns in the table, based on
either the name or the index. You can also map the columns manually.
Import Column Mapping

A new table can be created for the imported data. The data type for each column
is determined automatically from the data and the specific types supported by
the database. You can adjust the types manually.
Import to a new table
Feature DbVisualizer
» Import table data from CSV or Excel files
» Support for BLOB, CLOB and binary data
» Support multi-character column separator
» Automatic data type detection
» Automatic mapping of file columns to table columns
» Create table from imported data
» Save settings between sessions