would like more info on append paste

[Kathy R.]

Could you perhaps explain in a little more detail how a
paste append function works. I'm not familiar with that
approach and would appreciate some specifics on how to do
it. One thing i tried last night was to import the
spreadsheet into a new table. then i did an append query
to add those records to my existing table, but resulted in
lots of key violations and validation rule violations...
guess i need to go "back to the drawing board". Thanks!

-----Original Message-----

I've learned that the best way to bring excel data into
Access is to use the "paste append" function instead of
the "import" function. I have successfully added
information to Access this way into a table that already
had values.

If the duplicated field is your primary key, Access will
give an error message because primary keys can never be
duplicated. Access can also put these duplicates in a
separate table called tblError. Then you can go through
and delete or fix as necessary. But I think Access
usually takes teh curren table as the correct one, and
you'd have to use the tblError to correct those.

.

..