ObjFSO.CreateTextFile field export help

Hi there,

I wonder if anyone can help me , I am exporting ms access fields to an ms excel file using the method below.

set objFSO = CreateObject("Scripting.FileSystemObject")

thePath = server.MapPath("/adminsys/log_reporting.xls") set theFile = objFSO.CreateTextFile(thePath, true)

On all basic text fields and numeric fields this is working fine, however on memo fields there are some characters within these which must be breaking the field contents across multiple fields in the ms excel output file.

I have removed all "vbcrlf" entries from the ms access memo field contents, before this gets output to the ms excel file, however there must be some other character/s which are also causing the data to break across multiple excel fields, when this should all be contained within one field.

If anyone could let me know what other character/s I need to replace/remove before outputting to ms excel, other than vbcrlf, that would be ever so much appreciated.

Thank you in advance for any help you can offer,
Gia