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
