Importing excel fields to a single memo field

  • Thread starter Thread starter judith
  • Start date Start date
J

judith

I have some addresses in Excel as several columns of
data, Add1, add2, etc . I would like to put them in a
single access memo field but each excel field should be
on a separate line. I need them in a single field as I
want the facility to copy and paste the address from the
access database. I have tried concatenating the excel
fields with Char(10) and then importing but this doesn't
seem to work.

Any ideas please
 
Probably it is better to keep them in separate fields and combine them in a
query as needed. Chr(10) alone is not enough to display the data properly
in a text box, use vbcrlf constant (Chr(13) & Chr(10) ) for concatenation.

Addr1 & vbcrlf & Addr2
 
Back
Top