MySQL Excel connection/ coversion

Hi Guys

I need some help in converting EXCEL Vlookups, If, etc... functions to

convert them into Update and Insert Queries

in the Mysql Table.

I need someone who has experience in Advance Excel and mysql. The winner bidder i will send him the excel and more specified requirements

## Deliverables

I have a Big Excel Table for example (A1 to D1) that I update from a txt file (Import), now Colums E1 till Z1 for example contain functions that

are vlookups, if, INdex, match , etc..

and this excel sheet I want to transform it mysql so that It doesn't take me alot of time copying and pasting, refreshing formulas, etc....

so the functions that I want to transform to mySQL are:

I need to update/ insert fields in the same table

Below is some of the excel function in the cell:


Mapping_TAB is a sheet that contain small tables that I lookup these values from, so from my side I will import them to separate tables.




the winning bidder i will forward the excel sheet and the requirents

Evner: Ingeniørarbejde, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning

Se mere: php and mysql connection, p.c. connection, N2, i need excel help, advance excel+, vlookup table, need excel help, excel advance, Vlookup, mysql index, excel vlookup, excel table, excel function, Excel Formulas, excel ex, advance excel, php import excel file mysql, excel file mysql, txt convert excel, mysql convert text

Om arbejdsgiveren:
( 9 bedømmelser ) Saarbr?cken, Germany

Projekt ID: #3520170

2 freelancere byder i gennemsnit $26 på dette job


See private message.

$25.5 USD in 3 dage
(268 bedømmelser)

See private message.

$25.5 USD in 3 dage
(9 bedømmelser)