Need mysql memo rich text for Word import

[ellenr]

I am setting up a table to contain minutes for several years for an organization. The tables are contained in a mysql odbc database. The body field is set up as a med. text field. When linked into my Access 2010 front end, it comes in as a memo field. I can easily set the input form field as rich text. I cannot copy and paste .doc formatted text into this input form successfully--it won't understand tabbed fields, for example, making a mess of the formatted information. Somewhere I read that I could import formatted documents from Word if I also set the text format field in the table defs to rich text, but my message when I try to save that change is "Operation is not supported for this type of object" -- I am assuming the problem is mysql?

Any help for how to copy and paste formatted text from Word into memo field?

Thank you!

 

[Ranman256]

I've never seen access do formatting as good as word.
ID keep the word documents, and store the path of the doc in the db.

 

[ellenr]

You are correct, of course. If this didn't need to be in a mysql db backend to the shared Access program, that would be easy. Storing them in the mysql db, the files can be searchable, also.