Results 1 to 2 of 2
  1. #1
    Don83 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    1

    Importing Abstracts -> Text containing newlines

    Hello there,



    i would like to create a table consisting of text passages. But i have a problem with it, explained in the following:
    Hello,
    as you see I just inserted a "newline".
    And once again!

    The problem is... when importing data, rows are created by splitting my textfile at the newlines.

    But of course i dont want this.
    I want that the split occures at controled splitpoints.
    Anyone knows how i can do this?

    EDIT: Ohw.. unfortunately you can not see the tableborders i just inserted ;(. Hope you still get my point/problem.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    Why is the text split at newline? What method is used for the import? What should determine record breaks? Show example source data. If you want, can attach file to post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Importing A Text File
    By steve2507 in forum Access
    Replies: 5
    Last Post: 02-28-2012, 01:48 AM
  2. importing hyperlink with text
    By Mak_kap in forum Import/Export Data
    Replies: 9
    Last Post: 02-10-2011, 07:38 PM
  3. Replies: 1
    Last Post: 11-05-2010, 04:31 PM
  4. Importing text data
    By gsashwin in forum Import/Export Data
    Replies: 1
    Last Post: 06-28-2010, 06:40 PM
  5. Import to text - only text value NOT importing
    By Gerry in forum Import/Export Data
    Replies: 10
    Last Post: 03-26-2010, 06:55 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