Đã hoàn thành

144469 Database project.

I have data in the form of MS Excel spreadsheets that I get monthly. Each spreadsheet contains duplicates plus the number of columns may vary. What I want is to setup a database table where while loading first it identifies the correct columns to load and load only them and if the record with same key already exist it will update this record with the new record, but only where the data is not NULL, so it will not overwrite data with blanks. At the end I need to dump this to MySQL DB.

Kĩ năng: Bất kì công việc gì, Microsoft Access, MySQL, PHP

Xem nhiều hơn: what is microsoft project, microsoft spreadsheets, database project, setup database excel, excel access table, php mysql load table, php load table, database project php, excel update mysql, database dump, monthly database access, excel spreadsheet database form, database project microsoft access, project update form excel, excel form access database, excel database update, microsoft access update form, excel access project, excel record project, project excel access, excel table mysql, monthly database excel, need correct data project, excel database form, excel access update table

Về Bên Thuê:
( 22 nhận xét )

ID dự án: #1890645

Được trao cho:


lets do it.

$75 USD trong 0 ngày
(334 Đánh Giá)