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. #38
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    Hello again.
    I had that a lot when I was working on the first version.
    I assume that you still have the error capture in place, if so before this line
    MsgBox "Error #: " & Err.Number & vbCrLf & vbCrLf & Err.Description
    add in

    MsgBox "record - " & reccount & "  field - " & i

    this will tell you what record and field is causing the crash.
    Last edited by Aussiebear; 12-28-2024 at 08:27 PM.

Posting Permissions

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