Importing data from Excel, CSV, etc.

Help
2011-09-09
2013-04-29
  • Roberto Neyra
    Roberto Neyra
    2011-09-09

    Hi,
    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?

     
  • Heiko Hilbert
    Heiko Hilbert
    2011-09-09

    Hi,
    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.

     
  • Roberto Neyra
    Roberto Neyra
    2011-09-09

    Ok, Thanks for the reply. I had already thought that solution. Do you know if that functionality will be implemented in another version?

     
  • Heiko Hilbert
    Heiko Hilbert
    2011-09-09

    It's currently not planed.

     
  • Troy Coats
    Troy Coats
    2012-05-17

    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!