| Re: Import data from Access to Oracle [message #101914] |
Tue, 20 November 2001 20:37 |
Dinesh
Messages: 31
Registered: October 2001
|
Member |
|
|
Hi Tariq,
By doing the following steps you can load data from excel to oracle.
1.save excel file as '.CSV'(ex: vad.csv)
2.then write a control file as(in note pad)
load data
infile 'vad.csv'
into table TABLENAME
fields terminated by ','(col1,col2,col3......)
(save this file and rename it to .ctl file)
3.then in dos prompt
sqlldr userid=username/password control=FILENAME.ctl
that's it
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
