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

  • Thread starter One Handed Man [ OHM ]
  • 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
 
V

Van T. Dinh

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

Nearly there. You need 13 & 10 in this order.
 
O

One Handed Man [ OHM ]

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...
 
K

Ken Snell

Line breaks in ACCESS are a combination of ASCII characters 13 and 10 (in
that order).
 
Top