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

[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

[bhavin1988]

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

[mdsami]

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

[rtlakshmanan]

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

[Pilgrim333]

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]

you can use sql loader or any other transformation tool like Kettle for the purpose.

[amitpatel66]

SQL Loader or External tables. you can use either of them. You can find lots of information about both by web searching

[cgfjpfg]

DMC csv to sql

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