Access - How do I export a memo field as a csv file? 1

[Yooooda]

I have an Access database where each record in the database consists of one memo field. I have some VBA code that concatenates the fields into a comma separated variable (csv) list and puts it in one memo field/record of another table. The resulting data is more than 255 charactersso I cannot use a text field. Attempting to export the memo field results in a blank file.
I need to export that field as an actual csv file for another application to use.
Any suggestions?

 

[gradley]

You may have to substring the field into multiple values of 256 characters each, or try converting the value to a varchar(8000)

CONVERT(varchar(8000),Meno_Field)