ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Memo format field data problem - Data import from Access database (https://www.excelbanter.com/excel-programming/427726-memo-format-field-data-problem-data-import-access-database.html)

AFSSkier

Memo format field data problem - Data import from Access database
 
I have an Excel sheet that is refreshable through an import from an Access
database query connection.

When a memo formatted €śComment€ť field is imported, I get the following
entered in the €śComment€ť cells:
<div<font face=Arial size=2 color="#006666"REPORTS FOR 6-10-09 ARE READY
TO DO</font</div <div </div

The €śComment€ť cell should say €śREPORTS FOR 6-10-09 ARE READY TO DO€ť.

I dont get this when I export directly from the Access database to Excel.
However, I do get the hard return characters.

--
Thanks, Kevin


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com