I have data in Access & Excel with identical headers and a unique account number on each. Is there a way I can have access read that excel table and for what ever accounts it finds have it import to access and update those accounts and if the account does not exist have it create a new record with the new account number. I'm new at this and I have no coding experience.
Ex: In Access, the record for Account 255 has fields "Name" "Amount" "Qty", if the excel sheet says that account 255 has a QTY of 3 and Access shows Qty 2 I want Access to import the new Qty and update account 255.
Hope someone can save me with an easy script I can modify :-)