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. The data can be imported to a new table created based on the data in the file.

 

                  
The file viewer show the file as it look 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. 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
Pro
DbVisualizer
Free
» Import table data from CSV 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