Home » Other » General » Re: Import data from Access to Oracle
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


----------------------------------------------------------------------
Previous Topic: Re: Oracle8i startup passwords
Next Topic: Re: Migration from SyBase to Oracle
Goto Forum:
  


Current Time: Sun May 19 15:58:52 CDT 2024