Answer Posted / 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

What's the difference between a primary key and a clustered index?

1024

---

Is sql a dbms?

1059

---

what are different types of collation sensitivity? : Sql dba

1115

---

How do I sort a table in sql?

1080

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1011

---

What is date functions?

1088

---

What are the benefits of triggers?

1217

---

What is synonyms?

1118

---

Does sql full backup truncate logs?

1077

---

what is error ora-03113: end-of-file on communication channel?

1225

---

What are the most important ddl statements in sql?

1184

---

what happens if you no create privilege in a database? : Sql dba

1046

---

Does oracle use sql?

987

---

difference between anonymous blocks and sub-programs.

1188

---

how to rename an existing table in mysql? : Sql dba

1114

---