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