Numeric Overflow

Beerbrewer

Registered User.
Local time
Today, 13:53
Joined
Jul 18, 2002
Messages
22
I'm trying to append records from a linked .txt table into an Acces table. The .txt file is formatted as a report so columns contain different datatypes (headers & columnnames are text while the data can be numbers). Creating the linked table I have formatted some fields as numeric so the columnheads have a Null value.
The first time the appendquery runs succesfully but the second time I get a "numeric overflow" error.
How can this problem be solved?
 
Search the forum for "overflow", there are some topics to be found.

RV
 
Thanks for your reply, but i already have. All topics with "numeric overflow" remain unanswered. There is even somenone with exactly the same problem - but no solution.
 

Users who are viewing this thread

Back
Top Bottom