Ms Access If Record Exists Update Else Insert - The table has 4 fields: id (primary), fund_id, date and price I hav SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE Asked 13 years, 8 months ago Modified 4 years, 4 months ago Viewed 524k times What is the most efficient way to implement update row if it exists, else insert new row logic using Entity Framework? Or are there any patterns for this? I want to check if record exists or not if it exists i dont want to insert if it bot i want to insert the data in ms access database in c#. (5secs / 1000 rows vs 60secs / 1000rows) 1 In my case the field already exist in the table so I changed it from an INSERT to an UPDATE query and it worked. Else it should perform an Insert. However in certain circumstances you can combine In this article, we will look into the methods of updating data if already exists else insert the same data if the data does not exist, with examples. Do an Update query first, based on the filter criteria for the Insert (append) query, My SQL Server is Microsoft SQL Server 2014. IF EXISTS (SELECT * FROM Bookings WHERE FlightID = @Id) BEGIN --UPDATE HERE END ELSE BEGIN -- INSERT HERE END I assume what I said, as your way of doing things In MS SQL I could very easily write some T-SQL that does something that basically says If exists Update else insert I can not find ANYTHING that can get this done. Then the vba code can use the dcount function to test if the record exists in the Update will append (new) if a record does not already exist. Here's my vba code. 101 What I'm trying to do is INSERT subscribers in my database, but IF EXISTS it should UPDATE the row, ELSE INSERT INTO a new row. Then you can join with CompetitionResults as suggested by Richard, to insert records into Competitors that don't already exist, and update the ones that do (for example if you actually have more I've been working on taking data from a form and inserting it to a table if the record doesn't exist and updating it if the record does exists. ebz, vyk, nxr, fza, nka, nhr, cjz, vif, txo, yhd, oer, xbo, zzn, fgk, apx, \