|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 ssrg |
|
#2
|
||||
|
||||
|
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).
|
|
#3
|
|||
|
|||
|
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! Gerrit-Jan Linker www.oraxcel.com (SQL*XL) |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Text/Excel file to Oracle db |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|