November 22nd, 2003, 09:01 PM
Text/Excel file to Oracle db
I have my data in either a text or Excel file delimited by a comma. I would like to upload these data into the oracle database. Could someone tell me how to do this.
Thanks in advance
November 23rd, 2003, 05:08 AM
Excel won't be an easy task (from oracle's point of view), export to csv or other textual file and import with SQLLoader or External tables (9i and above).
December 19th, 2003, 09:40 AM
To insert Excel data into Oracle is easy using the SQL*XL addin for Excel. You may want to check it out at www.oraxcel.com.
SQL*XL expects as input:
1. the table name
2. the column names
3. the address of the range that contains the data
SQL*XL's dialogs help you to complete the input list. You can use the mouse to select the cell ranges etc.
Have a look at SQL*XL at www.oraxcel.com
Any question, just ask!