Posted on: 2/21/2015 3:38:16 AM | Views : 660

All,
 I have an excel file in a blob oracle field. What I want to do is to grab the file from the database, read the file using oldb and loop through the contents so I can process the data. My issue is when I get the blob from the oracle blob, how do I put that data into an excel object to read the worksheet? I know it has to be something like below.
Dim docArray As Byte()
        Dim ds As New DataSet                   ds = CSModule.read_file(iUserid, iDocId, iFileId, 1)             docArray = ds.Tables(0).Rows(0).Item(0)'blob field             Dim stream As Stream = New MemoryStream(docArray)< ...

Go to the complete details ...