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