Hi George,
Thanks for the suggestions. Unfortunately, after running the Find Unmatched
query, then attempting to append to my Accounts table, I still get the same
message:
"... Database can't append all the records in the append query. ... set 0
field(s) to Null due to a type conversion failure, ... , and 11 record(s) due
to validation rule violations."

I tried just adding one field "ContactName" to the QBE grid and still got
the same error. Can you help me understand the error message -- validation
rule violation? Both fields are text, field size 50 in Access, 255 from the
Excel imported table. Do the field sizes make a difference? If so, so I
need to make sure all the field properties are identical in both tables
(hopefully not, since I would have to do this with every import). I do have
required entry fields in Accounts, but was not using those fields in the
query.

Any other ideas? And thank you so much for your time.

Nancy

"George Nicholson" wrote:

A rough outline of one possible approach:
-Import Excel data into a new table (or, this could be an existing empty
shell that you import to every month and clear out before importing again)
-Create a "Find Unmatched" query to identify any account names in the new
table that don't exist in your accounts table (a one-time step. You don't
run this by itself, per se, it is used by the next step.)
-Append "Unmatched" records to Accounts.

-Append "Unmatched" Comments to Comments table (using Account Name to get
the new ID# from Accounts?)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"NNester" wrote in message
...
I have an Accounts table which contains customer/lead info. Many times I
receive new names (& complete contact info) in Excel worksheets. I've
tried
everything I can think of to append the new records into my Accounts
table,
i.e. Get External Data/Import to an existing table; Import to a new table,
then running an append query to the Accounts table. Nothing works! I get
en
error message saying the records cannot be appended due to validation rule
violations.

My Accounts table primary key - AccountID - is autonumber. My Excel files
don't have an AccountID field. Any help is so much appreciated. Right
now
I'm copying & pasting, which for one or two is ok, but sometimes there are
hundreds of records. Also, if there are comments in the Excel record, I
need
comments to be appended into a separate Comments table, but tied to the
Account record they belong to.

Can somebody help me?
--
TIA, Nancy