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?
The first time the appendquery runs succesfully but the second time I get a "numeric overflow" error.
How can this problem be solved?