by Serge » Thu Mar 21, 2013 12:03 pm
DBeaver 2.1.0 has new feature - Data transfer. Generally you may import data into database table from another database table.
To perform import from CSV (or DBF or Excel) you have to use JDBC driver for CSV (DBF or Excel) - there are plenty of them, many are free to use.
Then you need to create connection to your CSV (Excel) file and export some particular csv file into your database table (right click on table, click on Data Export menu item).
Data transfer wizard allows columns/types mapping tuning.
Please ask any questions concerning data transfer feature. Any feedback is welcome.