| importing data into Oracle Database [message #73963] |
Wed, 11 August 2004 07:24  |
Tiffany
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
Hello.
I need to import data into an Oracle 9i database. What form should the data be in? (Currently its in Microsoft Word.)
What do I need to do to get the data into Oracle?
All information will be appreciated!
Thank you!
Tiffany
|
|
|
|
| Re: importing data into Oracle Database [message #73966 is a reply to message #73963] |
Wed, 11 August 2004 20:41  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Put all you data in plain text file, separate each fields with a special character like , and use SQLLDR to load data from that text file into oracle tables.
For more info about how to use SQLLDR refer oracle doc.
Best of Luck
Daljit Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
