How to convert ms-excel file to oracle table?
Answers were Sorted based on User's Feedback
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 |
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 |
Can we insert data into view?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
What is normalisation and its types?
How many indexes can be created on a table in sql?
What is a pdo connection?
Does view store data in sql?
what is heap table? : Sql dba
How do I view an execution plan in sql?
What are three advantages to using sql?
Are stored procedures faster than queries?
how to enter numeric values as hex numbers? : Sql dba
What are the sql aggregate functions?