Importing data from Excel, CSV, etc.

Help
roneypc
2011-09-09
2013-04-29
  • roneypc

    roneypc - 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.

     
  • roneypc

    roneypc - 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!

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks