MS SQL Excel Spreadsheet Update Select Conditional Values in Table
Query to update SQL Database from Excel File
barcode = Asset_Code
Cost = Cost
Estimated Resale = Est_Resale
Insured Value = Insured_val
Where values in SQL Database are 0 or blank replace with values from Excel
file where barcode field matches.
Columns in Excel file match those of the database.
SQL Table contains many other fields/columns of data, but only the 3 values above are to be updated.
Will provide Excel file attached sample.