"Substitute with" in Access 1

[Fanny]

I need to import a Word database into Access. But I cannot succed in doing it : in each square and between each line in a square, is used the command "enter" (i.e.new paragraphe).
So in Word I needed to "subsitute" this command (with a simple symbol)in all my file. (I finally could found how to do it: new paragraph is : ^p) And then I could export it in Access.

The problem I have now is that I would like to do the contrary in Access. But the Function "substitute" in Acces does not give me the opportunity to change a symbol into the "new paragraph " command : How could I enter "control+enter" (which is the command of new paragraph in Access) in "substitute with" ?

I am very new in Access and I would appreciate a help step by step.
i know that could be done with visual basic or SQL, but I don't really know who it works
Thanks a lot for any help
Fanny

 

[mrichards]

can you give us a sapmle of the table that is produced.

Mark

 

[Fanny]

Hi Marc

It is impossoble to copy and paste a sample. And Attachment are not allowed.
I try this way
In word : 4 columns : 3 first one for codes , 4th one for product description (with the command new paragraph used after each phrase !!!!) 500 lines! (35 files!!)
In access : 4 columns : 3 first one for codes , 4th one for product description.

I hope you will understand (!!!)or perhaps you have a e-mail address available with possible attachment.

Bye
thanks in advance
Fanny

 

[mrichards]

Send it to me at mrichards3@hotmail.com if I have some free time I will look at it over the weekend.

Mark