Inserting records from Access to SQL 2000 Gets error of "OVERFLOW"

[VicRauch]

I'm using Access 2002 and I am using a query within an Access DB to insert records (the whole table) into a SQL 2000 table. All I'm getting is an error box that states "Overflow" Where should I look to fix this problem?

I have checked the data in the Access table, and fixed some dates, but now all the data is easily within the range of the respective data types for each field.

Thanks in advance,
Vic

 

[danvlas]

Check the data types in the SQL table for tinyint, smallint, smalldatetime.

For such fields, check the corresponding Access field, probably it's larger. If this is the case, change the type in SQL: tinyint->smallint or int (or even bigint), smalldatetime->datetime

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Crowley16]

also check for char() or varchar() fields

--------------------
Procrastinate Now!