Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace special character when exporting to Excel

Status
Not open for further replies.
RottPaws

RottPaws

Programmer
Mar 1, 2002
478
US
When exporting a recordset with a memo field to Excel, if the field includes a special character (i.e. Enter) it is displayed as a square in Excel.

Does anyone know of a way to replace the special characters with something that will not show up as a square in Excel?

Thanks in advance! _________
Rott Paws

...It's not a bug. It's an undocumented feature.
 
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
496
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
377
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
387
Moss100
Moss100
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
216
combo
combo

Part and Inventory Search

Sponsor

Back
Top