I have problems importing text with manual line breaks (<L>) or paragraphs (<P>) into MS Access field without loosing this formatting.
I've tried many different text or document file formats.
It was *.csv, tabulated e.t.c. but always when Access's import master senses <P> or <L> it breaks the record and splits it over more than one field.
I was able to preserve formatting when I marked for example 3 lines with <L> or 3 paragraphs made with <P> sign in MS Word or Notepad and then copy them to one specific memo field cell in MS Access. But when I tried this method to two or more memo fields simultaneously I failed again and there was only one line or paragraph per one memo field.
I also succeeded when I made table in MS Word exactly what I wish to look it MS Access and saved it as *.html and after this I imported this *.html into MS Access and this solved my problem with preserving line or paragraph formatiing in memo field, but unfortunetly there was other problem I still failed to figure out - during importing it looses a lot of meaningful spaces between words in memo field. There is example :
"... executivedirector of GRG Goup Ltd. Mailing address in file provided by MK on 20020717was different (Novell House, Level 10, 45 Wellesley Street). Probablysomething is wrong with addresses or phone number. Mailing Address in ACT DBleft the same"
----
Do you have any suggestions and tips how to solve this problem ? DO I have to do VBA scripting in MS Word or Access ? Maybe its something much more simpler ?
I've tried many different text or document file formats.
It was *.csv, tabulated e.t.c. but always when Access's import master senses <P> or <L> it breaks the record and splits it over more than one field.
I was able to preserve formatting when I marked for example 3 lines with <L> or 3 paragraphs made with <P> sign in MS Word or Notepad and then copy them to one specific memo field cell in MS Access. But when I tried this method to two or more memo fields simultaneously I failed again and there was only one line or paragraph per one memo field.
I also succeeded when I made table in MS Word exactly what I wish to look it MS Access and saved it as *.html and after this I imported this *.html into MS Access and this solved my problem with preserving line or paragraph formatiing in memo field, but unfortunetly there was other problem I still failed to figure out - during importing it looses a lot of meaningful spaces between words in memo field. There is example :
"... executivedirector of GRG Goup Ltd. Mailing address in file provided by MK on 20020717was different (Novell House, Level 10, 45 Wellesley Street). Probablysomething is wrong with addresses or phone number. Mailing Address in ACT DBleft the same"
----
Do you have any suggestions and tips how to solve this problem ? DO I have to do VBA scripting in MS Word or Access ? Maybe its something much more simpler ?
