append query

[slimjen]

All, Using access 2003 frontend and sql server 2008 backend. I have an append query to insert 80000 from one table to an empty table. I get an error:



"Microsoft Office Access set 0 field(s) to Null due to a type conversion
failure, and didn't add 36000 record(s) to the table due to key violations, 0
record(s) due to lock violations, and 0 record(s) due to validation rule
violations."

I know this error normally comes if there are dups in a field that doesnt allow.

I checked for duplicates and there are none. I can't seem to find the problem. Any ideas?
Thanks

[Rawb]

Can we see the table layouts and maybe some sample data?