Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert data from excel to table

vinOct 26 2010 — edited Nov 9 2010

Hi all,

I have a excel sheet which has two columns call_sign and clear_dt which has around 5000 rows.
I have a table Clear_date which has different columns including call_sign and clear_dt.

Can someone pl help me how can i select data from this excel sheet and then update the same in the table.
I use SQL developer or Toad.
The query should be something like , i give the excel sheet location and the data should be pulled directly from excel sheet and updated in table.

Please explain in detail, I am new learner.

Thanks All.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2010

Added on Oct 26 2010

#database-key-features, #export-import-sql-loader-external-tables

4 comments

4,630 views