Anand

• Jul 12th, 2006

 

You can use the sql loader for upload the csv file into your database tables.

Sanjay Chauhan

• Feb 21st, 2007

 

use the sql loader for upload csv file into database

Steps how to load?
1. create control file in notpad like

load data
infile 'path of csv file'
insert/append into file file_name
fields terminated by ' ,'
optionally enclosed by ' " '
trailing nullcols
(col1,col2,col3,.......)

2. Save this control with .ctl extension

3 Goto command prompt and run the query like

c:> sqlldr userid=apps/apps control =(path of ur control file with .ctl extension)

Chiranjeevi Manne

• Mar 30th, 2007

 

Why don't you use SQL Loader, it is real fast and easiest way of loading the data in oracle from flat files.

gtomar

 Profile Answers by gtomar 

• Jul 28th, 2008

 

Hi,

If you are using toad then you need to follow steps given below :-

1. login to toad .

2.Go to DBA < Data import/export < Sql data wizzard
<Choose .csv file  (Browse from the saved location)
< Finish

3. upload data into desired table .

Thanks,
Gunjan

Ravi Kanojiya

 Profile Answers by Ravi Kanojiya 

• Aug 17th, 2009

 

If you are usin php myadmin, click Import->CSV using LOAD DATA->Fields terminated by-> here use "," at the place of ";"