adodb.stream File Formatting

[canuckbear01]

Hi all.

I'm using ADODB.STREAM to extract a database embedded word document. However it seems to lose its formatting. When the document generated is opened its opened as if it was all text, i.e. lot of junk characters mixed in.

Any ideas?

Thanks,


Dim strSQL As String
Dim ors As New ADODB.Recordset
Dim FileStream As New ADODB.Stream
FileStream.Type = adTypeBinary

ors.Open strSQL, oConn

FileStream.Open
FileStream.Write ors!BlobFile
FileStreamSaveToFile "C:\BlobFile.doc", adSaveCreateOverWrite

FileStream.Close
ors.Close

[canuckbear01]

When a document is embedded into a database BLOB file using C++ methods, can it even be extracted using stream object methods in VB?

I don't know C++ but believe that it uses some kind of container or adds some kind of header information in the BLOB along with the document.

Can these headers be parsed out? More precisely can the document or other attachment be parsed out using stream?

If anyone know anything about this topic, I'd appreciate the help, even names of publications I can pick up to expand my knowledge horizon.

Thanks!