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 |
What is the purpose of my sql?
How much does sql certification cost?
what is oltp (online transaction processing)? : Sql dba
What is trigger in pl sql?
how to increment dates by 1 in mysql? : Sql dba
Is sql developer case sensitive?
What do you mean by stored procedures?
What is data type in database?
What are sql procedures?
Is left join inner or outer?
how do you login to mysql using unix shell? : Sql dba
How do I run a pl sql program?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)