Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.
Solved
vb problem reading text from Word tables
Posted on 2012-12-26
I wrote a program that reads the cells of Word (2007) tables and puts the results into a database. Currently using Access 2007 memo fields. Everything is fine except that the carriage returns and line breaks don't carry over into the database. for some reason they are stripped so the resulting text is one long string. even a blank line in the text gets stripped out when it goes into the database.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Make sure the "Text Format" property (Not to be confused with the "Format" property) of the memo field is set to "Rich Text"
Can you give us some insight into your "Program" and how it inserts the text into the field?
If setting the Text Format to Rich text does not work, then another option would be to insert the text via SQL Inserts.
Something roughly like this:
CurrentDb.Execute "INSERT INTO Yourtable (YourMemoField) VALUES ('SomeText1' & '<br>' & 'SomeText2')", dbFailOnError
...With your "Program" converting whatever character the cr/lf is in Word, ...to <br> for Rich Text (HTML)
JeffCoachman
Can you give us some insight into your "Program" and how it inserts the text into the field?
If setting the Text Format to Rich text does not work, then another option would be to insert the text via SQL Inserts.
Something roughly like this:
CurrentDb.Execute "INSERT INTO Yourtable (YourMemoField) VALUES ('SomeText1' & '<br>' & 'SomeText2')", dbFailOnError
...With your "Program" converting whatever character the cr/lf is in Word, ...to <br> for Rich Text (HTML)
JeffCoachman
Active 7 days ago
Word does not records the line breaks, it records only the carriage return with one character only, Chr(13).
Access memo fields record line breaks as the more standard combination of 2 characters, Chr(13) Chr(10).
I would try something like the following:
textInBd = textInWord.Replace(Chr(10)
Access memo fields record line breaks as the more standard combination of 2 characters, Chr(13) Chr(10).
I would try something like the following:
textInBd = textInWord.Replace(Chr(10)
Featured Post
![[Webinar] Lessons on Recovering from Petya](https://filedb.experts-exchange.com/files/public/2017/7/11/dcb3272a-62a8-4274-a34e-d1771610ec3b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month5 days, 22 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.