How to load data from an excel file to a table [message #434778] |
Thu, 10 December 2009 12:07 |
astik.mondal
Messages: 14 Registered: March 2008 Location: Kolkata
|
Junior Member |
|
|
Hi All,
We have a requirement. We need to read an excel file from a server directory and load data into a table using PL/SQL program.
Here we shouldn't convert the excel file to csv/txt file and shouldn't use sql loader.
Is there any way to acheive this requirement?
Any input on this would be appreciated.
Thanks,
Astik
|
|
|
|
|
Re: How to load data from an excel file to a table [message #434787 is a reply to message #434781] |
Thu, 10 December 2009 12:37 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Another option that I have used (when line feeds in he Excel cells made CSV files problematic) was to export the data to XML from Excel, load that XML into an XMLTYPE variable/table cell and then run a query on that to load the data.
As a rule you should second-guess any "don't use X" requirement, unless it is also stated why X it shouldn't be used.
If you try to find a new solution without knowing why, you don't know if your new solution doesn't have the same problem that motivated someone to put in the "don't use X" requirement in the first place.
|
|
|
|
|