run-time error 3349 (A2000 SR-1)

Topic

New Reply

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”, “C:Documents 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?

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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!!

Reply | Quote

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!!

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote