Question

Locked

Cannot import richtext from memo field of an access database

By hans.weber ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Versions?

by Juanita Marquez In reply to Cannot import richtext fr ...

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.

Back to Windows Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums