I am outputing a memo filed from access to excel. The transfer from access to excel is sucessful but when I open the excel file the memo field had end of line characters in it. Is there a way to remove these characters when exporting?
Do Until rst.EOF
For iCol = 0 To rst.Fields.Count - 1
.cells(iRow, iCol + 1).Value = CStr(Nz(rst.Fields(iCol), ""))
iRow = iRow + 1