numeric field overflow

W

Wstanley

I keep getting an error message that says "numeric field overflow" when I try
to import data after I split my database into a front and backend database.
The data will only import to the table before I split the database. Please
help??
 
D

Duane Hookom

I expect there is a change in the file you are importing. Just to test this,
import your table back into your FE and attempt the import.
 
W

Wstanley

Actually, the data is the same. The problem occcured after I tried to add an
additional table to the backend database. Since then, the only way I can get
the data to load is by deleting all of the tables and importing the table
back in -- in other words it works as long as I do not split the database bac
out again. The error occurs after I split the database again.
 
D

Duane Hookom

I would try cut down the import to half then one quarter than small numbers
until it worked or didn't.

Can you import into a new table and then run an append query?

Are the some referential integrity issues with the imported data?
 

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