Member Avatar for choeychoco
choeychoco 0 Newbie Poster

Good day everyone. i have a vb6 program that attaches files in my database having an attachment field named ATTACHFILE. Saving files works fine but i cant upload/save file to a selected directory. I have the following code below . I was able to save it to my spcefied directory but i can't open the file.. Thanks in advance.

Set addfile = New ADODB.Stream
addfile.Type = adTypeText
addfile.Open
If IsNull(Adodc1.Recordset.Fields("ATTACHFILE")) = False Then
addfile.SaveToFile "" & App.Path & "\CELEBRANTS.xlsx", adSaveCreateOverWrite
End If
addfile.Close
 Set addfile = Nothing
Edited by choeychoco
  • 1 Contributor
  • 0 Replies
  • 178 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.