Results 1 to 20 of 80

Thread: How to import a text file with more than 255 fields into Access

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #14
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    I have identified the problem after making a few corrections to the VBA and have it putting data into the table.
    However the lineinput statement is importing the whole txt file as one record, it is not recognising the Record delimiter, so it puts in just one record of 40,000+ characters.
    It also crashes on field 151 with "record too large".
    I am not sure how to overcome this issue of just one record, other than to try and split it up, to do so I need to identify the record delimiter.
    Last edited by OBP; 05-22-2017 at 07:45 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
  •