Home » SQL & PL/SQL » SQL & PL/SQL » Loading data into Oracle from Excel
Loading data into Oracle from Excel [message #209058] Wed, 13 December 2006 02:32 Go to next message
vishal gupta
Messages: 111
Registered: March 2001
Senior Member
My requirement is to load data into oracle from excel file(.xls).
I cannot use the external table option and sqlloader as the file is in .xls format and due to some restriction, will not be converted into .csv(it will be uploaded by users and users are not willing to change the file from .xls to .csv format).

Can anyone let me know about some other strategy to load excel data into oracle tables?

i am using 9i.

Re: Loading data into Oracle from Excel [message #209119 is a reply to message #209058] Wed, 13 December 2006 06:58 Go to previous message
Messages: 43
Registered: December 2006
Can be done through Oracle Heterogeneous Services or using any programming language supporting ODBC.
Previous Topic: about delete statement
Next Topic: Substitue characters in field
Goto Forum:

Current Time: Wed Aug 16 18:49:09 CDT 2017

Total time taken to generate the page: 0.11726 seconds