Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > oracle > answers

how to import data from csv file into oracle9i very very urgent

Newbie
  
Join Date: Aug 2006
Posts: 5
#1: Sep 27 '06
i hv a csv file and would like to import the contents of the csv file into oracle using vb6.0 or sql query

any comments suggestion will be appreciated
thnks
Newbie
  
Join Date: Dec 2006
Posts: 1
#2: Dec 8 '06

re: how to import data from csv file into oracle9i very very urgent

Quote:

Originally Posted by russel

i hv a csv file and would like to import the contents of the csv file into oracle using vb6.0 or sql query

any comments suggestion will be appreciated
thnks

hey pls reply me sir.i want the code for importing.csv file in oracle9i
Newbie
  
Join Date: Dec 2006
Posts: 2
#3: Dec 10 '06

re: how to import data from csv file into oracle9i very very urgent

U can use sql loader utility of oracle. Or you can use third party utilities like Data Loader in which u can transfer data between many databases and text files. website: http://www.dbload.com
Newbie
  
Join Date: Nov 2008
Posts: 1
#4: Nov 10 '08

re: how to import data from csv file into oracle9i very very urgent

how to import data from csv file into oracle9i very very urgent
Member
  
Join Date: Oct 2008
Location: Home
Posts: 127
#5: Nov 10 '08

re: how to import data from csv file into oracle9i very very urgent

Hi,

Well as stated above, you can use SQLLoader. If you want to import it by using a program, you can use UTL_FILE to open and read the file.

Please tell us more about your situation, if you want a detailed description of what to do.

Pilgrim.
debasisdas's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,505
#6: Nov 10 '08

re: how to import data from csv file into oracle9i very very urgent

you can use sql loader or any other transformation tool like Kettle for the purpose.
amitpatel66's Avatar
Moderator
  
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#7: Nov 10 '08

re: how to import data from csv file into oracle9i very very urgent

SQL Loader or External tables. you can use either of them. You can find lots of information about both by web searching
Newbie
  
Join Date: Nov 2008
Posts: 3
#8: Nov 30 '08

re: how to import data from csv file into oracle9i very very urgent

Quote:

Originally Posted by bhavin1988 View Post

hey pls reply me sir.i want the code for importing.csv file in oracle9i

Hi, Why not use a tool made for this purpose like this one ?
DMC - Convert Migrate Clone Transfer Visualize your data from any source to any destination

It will let you read ANY csv (or other source tables) and clone them to Oracle and transfer your data with zillions of features which can come very handy
Reply

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,374 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved