Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert MS Excel Data to oracle tables?

Status
Not open for further replies.
May 22, 2002
2
0
0
US
I have an excel file which i want to transfer the data to oracle. How do i get th'gh this. Do i need to convert the excel file to a comma separated file and use sqlload. If any one can help me by writing a piece of code that will be great.
 
SQLoader can do this - there are examples in the docs (utilities manual)
Alex
 
If you are using Oracle applications, you might want to look into Oracle Applications Desktop Integrator. Our accounting people use ADI all the time to upload spreadsheets directly to Oracle Apps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top