Probably less than 0.5 seconds to run through that.Since you would need to insert all the data into a table before you ran the most efficient solution (single UPDATE statement with joined table), you need to wrap the inserts inside a single Begin Trans... If you want to compare performance against one of the recordset methods already mentioned, you should also use a transaction.
If the two tables are both local Access tables, my update query is fine to run and can correctly update the data in the target table, but because one of the tables (the source table in my case) was a linked table, I kept getting this error.If you mean create a temporary table, update from that then then delete the temporary table What I typically do is NOT drop the table, but batch empty the data from it, and fill it For example Dim db As Database Set db = Current Db C Do Cmd. Execute "delete * from temp Billing Clone", db Fail On Error 'fill it with records from selected jobid Do Cmd. But I of course would have to check to ensure there is a recordset before attempting to update.Run SQL ("Insert into temp Billing Clone select billing ID, Job ID, Description, Date, quantity, Rate, account from tbl Billing where job ID = " & Previous. Would I have to convert the rate from a variant to the Double data type (this is what the field is set for) before attempting to update or will it accept a variant?I have found a way to extract the currency codes with corresponding rates (as variants) from a JSON file.So now I need to decide the best method to update my currency table (update existing records based on each currency code as opposed to adding new records).