asked on vb problem reading text from Word tables
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.
.NET ProgrammingMicrosoft OfficeMicrosoft Access
Last Comment
RBECKMN
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
-- original code that was causing the problem:
TheString = theTable.cell(ThisRow, 1).Range.Text
-- the code now is:
TheString = Replace(theTable.Cell(This
-- followed by:
therecordset(n)=theString,
TheString = theTable.cell(ThisRow, 1).Range.Text
-- the code now is:
TheString = Replace(theTable.Cell(This
-- followed by:
therecordset(n)=theString,
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