Importing data from an Excel sheet/file [message #74139] |
Sun, 19 September 2004 23:23 |
T. Sri Sai Krishna
Messages: 17 Registered: May 2002
|
Junior Member |
|
|
Hi,
I have an MS Excel file containing several worksheets. I want to know how I can Import this data into tables in Oracle. Is there a tool to do this ?
Do I need to export the excel data into a text file and use Sql*Loader to upload the information ? Will exporting the individual excel sheet to tab delimited files help in this?
Does MS Excel provide a way to export data in comma delimited format?
Your help in this regard will be greatly valued.
Thanks in Advance,
SriSai
|
|
|
|