| Loading data from excel to Oracle via forms; [message #431420] |
Tue, 17 November 2009 05:09  |
ashish.hussain
Messages: 8
Registered: July 2007
|
Junior Member |
|
|
Hi,
I have a requirement wherein it is required to access an excel file at some location and then load data from that excel to Oracle 10G database via Oracle 10G forms.
Would anyone know how this could be achieved ?
Would very much appreciate your help and prompt response.
Thanks/Regards,
Ashish.
|
|
|
|
|
|
| Re: Loading data from excel to Oracle via forms; [message #432412 is a reply to message #431420] |
Tue, 24 November 2009 00:42  |
ashish.hussain
Messages: 8
Registered: July 2007
|
Junior Member |
|
|
Hi Lin,
am not sure if I understood you.
Perhaps I could elaborate my requirement here:
I have an Oracle 10G Form, which would have a field to contain some path (Unix) along with a filename (xls).
And then, I want to process this file through some method in Oracle 10G Dev Suite, and be able to load it into the database.
I have been exploring the idea of Text_IO.
Could you or anyone else provide any inputs ?
Thanks/Regards,
Ashish.
|
|
|
|
| Re: Loading data from excel to Oracle via forms; [message #432484 is a reply to message #431420] |
Tue, 24 November 2009 07:51 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
If your excel file is .xls then text_io won't be able to read it.
Text_io is for reading text files. xls is a binary file.
Can you get the excel file in .csv format?
That's a text format will make your life a lot easier.
Assuming you get your data in text format I'd agree with linlasj and suggest you use sqlloader. It's specifically designed to load data from text files into the database.
Using forms to do this job just makes it more complicated than it needs to be.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
