I need to update a SQL table each day from an excel sheet. The complication is that each day new identifiers may be created in the excel sheet.
Therefore my first step is to check for new, non matching values in my excel sheet and add them to my SQL table, then I can use a simple update command.
I know how to do this between SQL tables by using the MERGE INTO command, does this mean I need to create a temporary table from my excel data and then use this?
If that is the case then does anyone have some code to create a temporary table from a single column in an excel sheet?
As a very new starter to SQL and a non-developer/coder I appreciate any help you can give.