Concluído

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, excel database update, excel data update, conditional fields, sql excel database, data data sql

Acerca do Empregador:
( 254 comentários ) Pasadena, United States

ID do Projeto: #2695130

Concedido a:

Lotusdeveloper

See private message.

$17 USD em 1 dia
(87 Comentários)
5.3

10 freelancers estão ofertando em média $18 para esse trabalho

bgeorge

See private message.

$20.4 USD em 1 dia
(230 Comentários)
6.1
NinadPatil

See private message.

$21.25 USD em 1 dia
(31 Comentários)
5.4
wesolvevw

See private message.

$21.25 USD em 1 dia
(46 Comentários)
4.4
bickos

See private message.

$17 USD em 1 dia
(16 Comentários)
3.4
intel183ins

See private message.

$20.4 USD em 1 dia
(26 Comentários)
3.3
icebreaking

See private message.

$15 USD em 1 dia
(5 Comentários)
2.2
mayankwebvw

See private message.

$10 USD em 1 dia
(0 Comentários)
0.0
loudanna

See private message.

$18.7 USD em 1 dia
(0 Comentários)
0.0
softwebcoder

See private message.

$15 USD em 1 dia
(1 Comentário)
0.0