1 Reply Latest reply: Apr 29, 2013 5:07 AM by Irian RSS

    Import to script from ODBC importer

      I want to import rows from excel file using ODBC importer in PL/SQL Developer, but I don't want to import it directly from the importer - I want the script that it generates to sql.
      Unfortunately, the button "Import to script" in the ODBC importer is unabled (grayed).
      Can someone tell me how can I get the script for the creation of the imported rows?
        • 1. Re: Import to script from ODBC importer
          You should probably ask this question in a PL/SQL Developer forum; this forum is for SQLDeveloper which is a different tool and does not support ODBC connections at all.

          If you want to give SQLDeveloper a try it does support Excel import (no ODBC required), and there is an option to generate an import script that might be what you are looking for.