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?
 

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

Back
Top