Importing CSV file into multiple tables using a script [message #345425] |
Wed, 03 September 2008 09:55 |
AlasdairCM
Messages: 3 Registered: September 2008 Location: London
|
Junior Member |
|
|
HI,
I have a csv file that is 8k lines long and I need to import it into multiple tables on my database. The format of the file is as follows
table1|a|b|c...
table2|a|b|c...
table1|a|b|c...
table3|a|b|c...
it goes on and on with the various different tables (18 in total) .
I'm trying to create a script that will run every night to process the data and put it into the table that is required as defined by the first column in the csv file.
Any suggestions on the best way to do this? I am an oracle novice so please be gentle!
|
|
|
|
|
|
|
|