HOW TO LOAD THE DATA FROM MSEXCEL TO ORACLE TABLE

[MURALI KRISHNA]

i have an ms excel sheet with one column and 862 rows

how can i load data from excel to oracle table not by using insert commands(it is difficult process)

how to load by using sql*plus loader

please send any code is there

 

[mike]

You can do it with PL/SQL Developer. Save the Excel file as a .csv. Then read the manual about the "Text Importer". This is section 19.7 in version 8.

 

[MURALI KRISHNA]

but i am using Version 7.0.3.1123 (MBCS)
and i didn't find that "text importer"
can you please mention the link to that page

thanks in advance

 

[Bernhard S]

You can always just use Excel to generate the insert DML using Excel functions. If you don't have too many columns in your table that might be easiest and most flexible.

 

[Jeff81]

How about just selecting the table for update, unlock it, and then just copy and paste from Excel. Don't forget to select and empty leading column in Excel though.