Importing excel fields to a single memo field

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
 
A

Alex Ivanov

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top