Thank you @Matteo NNZ for help with part 1, this is the code I am now using to update multiple columns So for part two, I haven't actually got anything sufficient to post but where I have specified a value in the string I would rather it be dynamic to loop through the excel table/column. Thanks @Matteo NNZ OK so I have managed to do part 1 which may or may not be the correct method but it works. This is how I have achieve it ' u SQL = "UPDATE Breach_Test_Key SET [VAL_BREACH_REASON] = ' SOME BREACH REASON' WHERE [ID] = 1" & _ "UPDATE Breach_Test_Key SET [VAL_BREACH_DETAIL] = ' SOME BREACH DETAIL' WHERE [ID] = 1" ' Please add your result to the body of your question, so that someone who knows more about it can help you to optimize the code and help you with the point 2. Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.As you proceed, remember that updating data is not the same process as entering new data.The ID field will always match as the data is from this table. Please could someone guide me through the SQL structure for this please?
Use the Refresh command (on the Data tab) to do this. In turn, those design principles affect how you enter data.Remember these facts about database objects and design as you proceed.Not all of my part numbers are being picked up in Access even though they exist in the Excel Workbook.It's not a formatting issue either because everything is formatted the same and all the other hundreds of part numbers and quantities were picked up.By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet.