Question Locked

Cannot import richtext from memo field of an access database

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I import an access view into a word document. The access view contains a memo field.

Instead of getting 'This is a text' the word document receives < div >< font color="#303030">< strong >This is a text< /strong >< /font>< /div>.

I was also setting the Text Format option of the access view to 'Richt Text', but there is no change.

Does anybody know how get the correctly formatted text?

Here the definition of the word field, which I added with the Insert Database command (The column 'Description' is the memo filed containing rich text):

{

DATABASE \d "mydb.accdb" \c
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;
Data Source=mydb.accdb;Mode=Read;Extended Properties=\"\";
Jet OLEDB:System database=\"\";Jet OLEDB:Registry Path=\"\";
Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password=\"\";Jet OLEDB:
Create System Database=False;Jet OLEDB:Encrypt Database=False;
Jet OLEDB:Don't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;
Jet OLEDB:Support Complex Data=False" \s
"SELECT `TableName`, `Atribute`, `Datatype`, `Description`
FROM `View_Datamart_Table` WHERE ((`DMTA_NAME` = 'dim_table'))" \h

}

Many thanks for your help

Hans Weber

2 replies

by juanita marquez

My Access is a bit rusty but I'll give it a go...It looks like it is either inserting it into your Word doc (which version of Word? Which version of Access?) as HTML. Have you tried making your destination document an .html format prior to the import? an .rtf format? is the default format .doc or plain text for the Word doc? If it is plain text (.txt) it may be displaying all the HTML code instead of just formatting it. Check the document format first and see what happens.

This discussion is closed to new replies.