Append Query

[Guest]

Hi. I am trying to append one table to another both existing in the same database, but when I tryr to run the query it gives me a very long error message! It says" Microsoft can't append all records at this time. Access set 4 fields to Null due to a type conversion failure & it didnn't add 0 records to the table due to key violations, 0 records due to lock violations & 0 due to validation rule viloations" WHAT! ?????? Thanks

 

[Kevin3NF]

"Access set 4 fields to Null due to a type conversion failure "

My guess is you tried to stick a text field into a number field, or some
such mix-up..Verify each source and destination "pair" have the same
datatype...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Hi. I am trying to append one table to another both existing in the same

database, but when I tryr to run the query it gives me a very long error
message! It says" Microsoft can't append all records at this time. Access
set 4 fields to Null due to a type conversion failure & it didnn't add 0
records to the table due to key violations, 0 records due to lock violations
& 0 due to validation rule viloations" WHAT! ?????? Thanks

 

[Guest]

Just answer YES, you'll see the query *should* work then.
It's just a warning message.

-----Original Message-----
Hi. I am trying to append one table to another both

existing in the same database, but when I tryr to run the
query it gives me a very long error message! It says"
Microsoft can't append all records at this time. Access
set 4 fields to Null due to a type conversion failure & it
didnn't add 0 records to the table due to key violations,
0 records due to lock violations & 0 due to validation
rule viloations" WHAT! ?????? Thanks

 

[Kevin3NF]

You sure? That looks like the informational message that comes AFTER the
one that says how many records will be appended...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Guest]

It will append all but the 4 records.

 

[Kevin3NF]

Then you have a data problem in those records.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm