Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2009
    Location
    Cleveland, Ober�sterreich, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have been using Excel as my primary data source for tables, and have run into a problem with importing. One xls spreadsheet I am using has one column of data entered as text that includes hard returns (not sure the exact term for this, but like hitting "Enter" in a word processing app). Access seems unable to deal with these, and truncates the data at the first hard return. Is there any way I can get around this so that these cells are imported in their entirety?

    Thanks,
    Matt

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Access 2003 doesn't truncate values at a line break, but it imports line breaks as a box character.

    Which version of Access are you using?

  3. #3
    New Lounger
    Join Date
    Feb 2009
    Location
    Cleveland, Ober�sterreich, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Access 2003. The line breaks appear in Excel as box characters, but nothing in the imported Access table beyond the box characters is displayed.

    I have attached the original xls file, as well as the imported Access Table (compressed).

    Thanks, Hans.


    Matt
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The text has in fact been imported correctly. Increase the row height in the table to see the additional lines.

    (Column U in the Excel sheet contains Carriage Return + Line Feed instead of just the Line Feed used by Excel. Access uses CR+LF, so the line breaks do show up there as line breaks!)

  5. #5
    New Lounger
    Join Date
    Feb 2009
    Location
    Cleveland, Ober�sterreich, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Amazing. Thanks for the help.

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •