Preserving Line breaks when importing text into multi line text boxes.

  • Thread starter Thread starter One Handed Man [ OHM ]
  • Start date Start date
O

One Handed Man [ OHM ]

Hi,

I am importing a CSV file into access and three of the fields are going into
Memo type fields. This all workds find, but I'm not sure what control
characters to embed in the strings to force a new line in access.

I have tried ASCII ( 10 ) (10) & (13) (9) ( 11).

None of these work. Can someone help ?

Cheers
 
(newgroups trimmed. Please restrict to a max. of 3 relevant newsgroups)

Nearly there. You need 13 & 10 in this order.
 
Many thanks - works fine now.



Van T. Dinh said:
(newgroups trimmed. Please restrict to a max. of 3 relevant newsgroups)

Nearly there. You need 13 & 10 in this order.
Click to expand...
 
Line breaks in ACCESS are a combination of ASCII characters 13 and 10 (in
that order).
 
Back
Top