Page 1 of 1

Import/Export Excel & XML

PostPosted: Sat Oct 13, 2012 10:15 am
by 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.


Re: Import/Export Excel & XML

PostPosted: Mon Oct 15, 2012 11:56 am
by Serge

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.


Re: Import/Export Excel & XML

PostPosted: Thu Mar 21, 2013 12:03 pm
by 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.

Re: Import/Export Excel & XML

PostPosted: Fri Mar 22, 2013 1:03 am
by 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.

Re: Import/Export Excel & XML

PostPosted: Thu Mar 26, 2015 1:05 pm
by rethus
Is there also a CSV-Import for the eclipse-Plugin Version of DBeaver?
Where can I found it?