Updating existing records and adding new records in table from Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2892447%22%20slang%3D%22en-US%22%3EUpdating%20existing%20records%20and%20adding%20new%20records%20in%20table%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2892447%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20that%20I'd%20like%20to%20update%20every%20day%20for%20the%20exiting%20records%20update%2C%20for%20the%20new%20records%20append.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20this%20to%20be%20done%20from%20an%20excel%20spreadsheet.%20So%2C%20first%20filter%20CRM%20ID%2C%20then%20updates%20this%20CRM%20ID's%20tasks%20based%20on%20TaskID%2C%20and%20if%20new%20task%2C%20add%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoogled%20and%20searched%20and%20tried%20something%20with%20Update%2C%20Delete%2C%20etc.%20queries%20but%20had%20no%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20or%20examples%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EAdnan%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2892447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I have a table that I'd like to update every day for the exiting records update, for the new records append.

 

I need this to be done from an excel spreadsheet. So, first filter CRM ID, then updates this CRM ID's tasks based on TaskID, and if new task, add it.

 

Googled and searched and tried something with Update, Delete, etc. queries but had no luck.

 

Any ideas or examples?

 

Thanks in advance,

Adnan  

0 Replies