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
 
You must log in or register to reply here.

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

Similar Threads

EXPORT QUery with memo field to excel, truncated data 2
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Importing Excel Data Into MS Access Memo Field 2
Exporting memo fields from Access to Excel 4
Import DBF files with MEMO fields 10
Losing data from memo field when exporting to Excel 6
transfer to excel 1
Memo Field - Append Text fields into memo field??? 1

Back
Top