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. #25
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    Here is what you want, it is quite fast considering it is bringing in the file a character at a time.
    You will have to review the key & indexed fields as I had to set some of them to Duplicates allowed.
    I think that the RecordID that I added should probably be an Autonumber field, otherwise at the moment each import will duplicate those numbers.
    Attached Files Attached Files

Posting Permissions

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