How to convert ms-excel file to oracle table?

Answers were Sorted based on User's Feedback



How to convert ms-excel file to oracle table?..

Answer / arup ratan banerjee

By means of Sqlloader

steps
------
1) Save the excel file as .csv
2) Give proper column headings
3) create a file named sqlload.ctl where u will write

load data
infile 'C:\HR_EMP_LWP_TMP.csv'
REPLACE
into table HR_EMP_LWP_TMP
fields terminated by ','
(emp_NO,yr_mon,lwp)

4) Load Oracle Client 9i

From command prompt run

c:\oracle_client9i\bin\sqlldr <user/password@tnsname>
sqlload1.ctl

5) The excel file gets converted to Table in Oracle

Is This Answer Correct ?    7 Yes 3 No

How to convert ms-excel file to oracle table?..

Answer / ts mishra dba

load data
infile 'c:\head.csv'
replace
into table allotment
field terminated by ',' optianally enclosed by '"'
trailing nullcols
(ALLOTMENT_ID,ALLOTMENT_DATE,DEMAND,MAGOR,SUB,MINOR,SCHEEM,S
EGMENT,OBJECT,DETAIL,AMOUNT,DDO_CODE)


run at run command this
sqlldr scott/tiger@ntts control=c:\head.ctl

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between a local and a global temporary table? : Sql dba

1 Answers  


suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  


what is hash join

1 Answers   NCR,


ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,


Mention what are different methods to trace the pl/sql code?

1 Answers  


How can you know that statistics should be updated?

1 Answers  


define data blocks ? : Sql dba

1 Answers  


what is the difference between union and union all? : Sql dba

1 Answers  


What is keys and its types?

1 Answers  


What are types of exception?

1 Answers  


Mention what is the use of function "module procedure" in pl/sql?

1 Answers  


How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,


Categories