MS SQL Excel Spreadsheet Update Select Conditional Values in Table

MS SQL Excel Spreadsheet Update Select Conditional Values in Table

Query to update SQL Database from Excel File

Database

DATABASE

Table:

Asset01

Values:

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.

## Deliverables

see above

Habilidades: Vale Tudo, Administração de Bancos de Dados, Engenharia, Microsoft Access, MySQL, Arquitetura de software, Teste de Software, SQL

Veja mais: spreadsheet engineering, field engineering, select, MS SQL, excel to sql, excel spreadsheet, database sql, excel contains, update sql file, spreadsheet columns, barcode query, excel sql query, sql select select, query spreadsheet, query barcode, update field sql field field, sql select, excel file columns, value engineering, update spreadsheet data

ID do Projeto: #2695130