Convert BLOB into a table
481088Jan 13 2006 — edited Feb 10 2006Hey,
I have a problem....
I am using the new Oracle XE and I want to load Excel Data (.xls) in an application which converts the Excel Data into an existing table.
My idea is, to load the excel form (.xls) into the file_subject table and after uploading the file the BLOB should be convert into the existing table. And the different columns should have different data types (VARCHAR2,NUMBER,DATE)
Has anyone an idea?
Thanks