Access 2007: external txt data

  • Thread starter Thread starter Gasperix
  • Start date Start date
G

Gasperix

I SUCCESSFULLY import in my database data from txt (tab delimited) file A.
Then I use make table query X to make table B:

SELECT A.* INTO B
FROM A;

The problem is that X works only once then the NAME OF QUERY has to be
changed (!!!??) to make it work for another time and that even if txt file
does not change.

When not working, I get the error message (it's in local language, so I
won't be translating it here) and within Help the following error:

Numeric field overflow. (Error 3349)
The data in a Btrieve field is too large to represent in your application.

Any ideas how to deal with this problem?
 
Back
Top