Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Kansas, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    run-time error 3349 (A2000 SR-1)

    I transfer a delimited (~) text file to my database daily. I have done this for seven years. I run this line of VBA code to do this: DoCmd.TransferText , "OrdTrail Import Specification", "Order Trailer", "Cocuments and SettingsGaryMy Documentsordtrail.txt" Now today something quirky is going on and I get the run time error. Can anyone give me a clue to why I might be getting this run-time error 3349, Numeric field overflow?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: run-time error 3349 (A2000 SR-1)

    I would take a look at the text file in Notepad or import it in Excel to see if, as the error message suggests, one of the numeric values is too large for the field size. For example, an Integer must be between -32,768 and + 32,767. A Long Integer must lie between -2,147,483,648 and + 2,147,483,647.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Kansas, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: run-time error 3349 (A2000 SR-1)

    Thanks Hans, I've looked at that--only the first two fields are numeric, the first is long integer with values between 10 & 99999 and the second one is integer with values between 1 and 999. I have numerous currency fields and about 4 text fields. Any other suggestions? I have looked at it in Word as a text file, as well as imported it into Excel and looked at it--but I can't find anything abnormal with it.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: run-time error 3349 (A2000 SR-1)

    Copy the first half of the total number of records in the text file to a new text file; do the same for the second half. Try to import each of the new files. If only one causes the error, repeat this procedure for that file. This should allow you to pinpoint the record that causes the problem. If both halves cause the error, something very strange must be going on.

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Kansas, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: run-time error 3349 (A2000 SR-1)

    Thanks for the help Hans, I did what you suggested--tried importing portions of it at a time. I found the problem--This order detail lines and a couple of lines on an order had the character ~ that I use as a field delimiter, so it was shoving all the data in those records on record too far to the right which tried to put numerical data into text fields. What a mess. It's been a long day. Thanks again!!

Posting Permissions

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