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 ...