W
Wladdy
Hi,
I have a Word document with a few hundred short stories.
Each story is under 10000 characters, and is made of paragraphs (ie:
groups of sentences ending by a paragrah sign ^p).
The first paragraph of each story is an integer which is the unique ID#
of that story.
I need to import the stories into an Access 2003 table with two fields:
[StoryID#] - an integer field
[StoryText] - a memo field
Now, how can I accomplish this and keep in [StoryText] the paragraph
structure of each story (ie: how do I import the text with line
breaks?).
I tried to reformat my Word file so that each [StoryID#] is followed by
a 'Tab', each paragraph except the last one of the story is followed by
'Line break', the last paragraph of the story is followed by
'Paragraph'. However, when I save into a txt file I lose all the line
breaks.
I tried another approach and replaced in the Word documents all the
line breaks with a unique string of characters (such as ****). I then
can save the txt file and successfullyt import it into Access. However,
I then cannot replace all the **** by line breaks in the [StoryText]
memo field.
Any guidance would be much appreciated.
W.
I have a Word document with a few hundred short stories.
Each story is under 10000 characters, and is made of paragraphs (ie:
groups of sentences ending by a paragrah sign ^p).
The first paragraph of each story is an integer which is the unique ID#
of that story.
I need to import the stories into an Access 2003 table with two fields:
[StoryID#] - an integer field
[StoryText] - a memo field
Now, how can I accomplish this and keep in [StoryText] the paragraph
structure of each story (ie: how do I import the text with line
breaks?).
I tried to reformat my Word file so that each [StoryID#] is followed by
a 'Tab', each paragraph except the last one of the story is followed by
'Line break', the last paragraph of the story is followed by
'Paragraph'. However, when I save into a txt file I lose all the line
breaks.
I tried another approach and replaced in the Word documents all the
line breaks with a unique string of characters (such as ****). I then
can save the txt file and successfullyt import it into Access. However,
I then cannot replace all the **** by line breaks in the [StoryText]
memo field.
Any guidance would be much appreciated.
W.