Importing records from Excel
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
|