what is the expansion of CSV file? [message #9099] |
Sat, 18 October 2003 07:00 |
saravanan
Messages: 70 Registered: October 2000
|
Member |
|
|
dear friends,
i am having data in excel sheet.
how can i translate that data to oracle database.
i recived some information from orafaq message related to that. that is i have to creat CSV file and use SQL loder.
please give the expansion of CSV and give the steps to convert the data from excel sheet into oracle database.
saravanan
|
|
|
Re: what is the expansion of CSV file? [message #9100 is a reply to message #9099] |
Sat, 18 October 2003 09:00 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
CSV = comma separated values
In excel,you should be able to save the file in a CSV format. Once you have that, prepare SqlLoader controlfile that interprets this ascii text file to match up with the table structure in the Oracle database.
Then you should be able to run sqlldr that loads your data into the tables using the controlfile....
-Thiru
|
|
|