Results 1 to 2 of 2
  1. #1
    mjwillyone is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    11

    Exporting Multi-Line Text Field Addresses to Excel - how to put info in different cells

    Hello,

    I have an Access database that stores addresses in text fields, and shows them on a form where the field can have multiple address lines. This is great when we are trying to copy/paste text for an envelope.

    However, I would like export the table and take the 3 or 4 lines of the address and list them in 3-4 columns of an Excel file. The first line of the table would be the first column of the Excel file. The second, the second. You get the idea.

    When I look at the exported Excel file (I have attached a sample) the address shows only the first line in each cell. You have to double-click the cell for all of the address to show.

    What macro can be used to take the one address (with multiple lines) and make it into multiple columns instead?

    Thank you so much!
    Mike
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I'd use the Split() function in a VBA function that returned a given column.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Problem exporting multi-line addresses to Excel
    By mjwillyone in forum Import/Export Data
    Replies: 4
    Last Post: 01-27-2016, 11:01 AM
  2. INSERT INTO from multi line text box
    By Only4Access in forum Forms
    Replies: 3
    Last Post: 01-08-2014, 08:06 PM
  3. exporting access report to specific excel cells
    By grgold14 in forum Import/Export Data
    Replies: 1
    Last Post: 02-07-2012, 04:38 PM
  4. Replies: 6
    Last Post: 04-07-2011, 12:33 PM
  5. Excel exporting in single cells
    By Paolo29011982 in forum Import/Export Data
    Replies: 0
    Last Post: 07-29-2009, 04:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums