Memo data type to text file.

[Paul]

How can I send the content of a memo data type to a text file using vb.

Thanks

 

[Tim Ferguson]

How can I send the content of a memo data type to a text file using vb.

' get an outbound stream
wFileOut = FreeFile()

' open it
Open "d:\mydata.txt" For Output As wFileOut

' write the memo field
Print #wFileOut, rs.Fields("MyMemoField").Value

' close the file
Close #wFileOut

' all done: now get another record or something.


You can look up Open, Close, Print #, etc statements in help. The syntax
for Open is pretty critical.

Hope that helps


Tim F

 

[Paul]

Yes it exacly what I was looking for.

Thanks,
Paul