Access 2007: external txt data

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top