Import/Export Excel & XML

[Wichart009]

I has use import and export result set, it work good and very fast. But I think if we can import/export directly from Excel instead of .CSV file is much better. And I have a new job to import data in .XML format to Database. If possible, may add import/export in .XML format.

Thanks.

[Serge]

Hi,

XML export feature is not a big deal, probably we will include it in the next version.
However data import feature is not yet implemented in DBeaver at all. It has many complex parts, especially concerning data type conversions and SQL dialoct differences so I'm afraid we won't include this feature in nearest version.

Thanks!

[Serge]

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.

[Wichart009]

Thanks a lot for you kindly support, Great!. I just have seen it, let me try out & I'll be feedback. if any further information, I'll let you know.

[rethus]

Is there also a CSV-Import for the eclipse-Plugin Version of DBeaver?
Where can I found it?