Importing Excel file into Oracle DB

[Former Member]

Hi,

We need to create a process for user to import Excel file into Oracle DB. This needs to be a self service function, so user front end component would be involved.

Thanks,

Anil

[sidnooradarsh · Accepted solution]

Hi Anil,

Go for any server side language in conjunction with HTML's File tag and javascript's FileUpload Object.

Something like this,

<FORM METHOD=POST ACTION="../UploadFileServerPrg">
File to upload: <INPUT TYPE=FILE NAME="upfile"><BR>
<INPUT TYPE=SUBMIT VALUE="Submit">
</FORM>

You can find many server side programs over net with some minor tweaks you can use as per your requirement.

Hope this helps!!

Regards,

Adarsh

[Former Member]

If you mean you want to import the file and store the entire file in a blob then I suggest using the Apache file upload functionality already in use elsewhere in MII to get the file in (I got some good help on the forum here in the past, ), then you should be able to google a procedure to get the file into the BLOB field.

If you mean you want to copy data from a fixed format spreadsheet into a pre-existing table in oracle, then I suggest using UDS to read the data (try topic ), then perform any validation in MII and copy the data to the DB. Use standard INSERT query for low volume, or oracle function/custom action for higher volume.

Hope one of these helps

Nick

Edited by: Nick Stannage on Mar 23, 2010 10:24 AM -

[Former Member]

Anil,

Did you check the below blog, here data will be imported into MS SQL. It may be quiet helpful for you.

/people/manisha.batabyal/blog/2010/02/23/how-to-migrate-microsoft-excel-data-to-ms-sql-database-in-mii-120

-Suresh