Loader is there in PLSQL Developer ??

[gshari23]

If i need to load 800000 records from (excel.xlsx) to a table ..
How can i do it???

 

[Marco Kalter]

You can either save the Excel file to CSV format and use the Text Importer or use the ODBC Importer and the Excel ODBC driver.

 

[Benjamin L]

If it's possible to saev the file as csv, you can also use an external table to access to the data.

 

[gshari23]

Will u please advise of loading 800000 records from (.xlsx) to the database. We have tried ODBC but its getting hanged..

I am not getting ur point .Will u please explain in detail

 

[NK]

1. Save the file as a .csv (not .xlsx)
2. In PL/SQL Developer, go to Tools, Text Importer and open your .CSV file using Open icon.
(notice it identifies your fields at the bottom)
4. Click on "Data to Oracle" tab, and name fill in the field names, table name, etc.
5. Click on Import (bottom-left).

I have used this tool to import multi-million rows successfully.

 

[Jeeva Shanmugave]

Does anyone have an idea on whether the Text Importer internally uses SQL*Loader to do the import?

 

[Jeeva Shanmugave]

Does anyone have an idea on whether the Text Importer internally uses SQL*Loader to do the import?

Difference between Text Importer and SQL*Loader

This kind of answers my question. Seems like both are different. SQL*Loader is a better choice when you want to load millions of records into your table.