I am trying to migrate structured documents (i.e. documents that are mostly some metadata and one big table) to a database. When I try to move tabular data from Word to Excel, my main point of pain is handling CRLFs within a cell in Word. Any solution for this? Now, since I will be transferring from Word to Access:
- What will be the default behaviour when I attempt to populate a field with a string that contains a CRLF?
- What is the cheapest way to get Access to respect "rich text"? (mostly boldface and overstrike)
Tnx