Exporting table to Excel file

[LaCour]

When exporting a table to an Excel file, there are problems with certain characters. When there is a newline in an Access field, a character that looks like some sort of wingding comes over in its place.

Does anyone know of any ways to avoid this or correct it once in Excel? FYI: In Excel, you can not do a find on that character - it is not found.

Thanks
Blair

 

[PHV]

You may consider using the Replace function playing with vbCr, vbLf and/or vbCrLf

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244