numeric field overflow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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.
 
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.
 
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?
 
Back
Top