I've looked all over this issue and it is very strange that nobody has needed before. Could anyone help me how to import data from an excel, csv, etc?
In the help I found this: "Export and import data from local files (not yet implemented, see v3.5.0.beta3) ", but I use SQLExplorer stand alone ver. 3.6.1 and I can only export data.
Please, anyone have any idea?
there is currently no import functionality implemented in SQL-Explorer.
If you use Excel you can generate the required insert statements like this:
="insert into t1(col1,col2,col3) values (" & A1 & ",'" & SUBSTITUTE(B1; "'"; "\'") & "'," & C1 & ");"
Be aware to enclose string values into ' and replace all ' contained in the string with \' like B1 in the example above.
Ok, Thanks for the reply. I had already thought that solution. Do you know if that functionality will be implemented in another version?
It's currently not planed.
The export feature works well… SQL Explorer seems to be very well written and I like that the UI is similar to Eclipse.
Data import would a nice feature to have.
Thanks your work and effort on this project!
Log in to post a comment.