Just create a single table, which for example you call tblDatas, with the eight fieldsCOMPANY DATE LINK NETWORK PRODUCT FORECAST SURGE ACTUAL
to manage the data of excel file 1 you must: connect the excel file via the link to a temporary table, for example tblTemp
- append in the tblDatas the records of the tblTemp that compared do not exist in the tblDatas and writing the value 0 in the ACTUAL field.
- delete the tblTemp table.
to manage the data of the excel file 2 you must:
- connect the excel file via the link to a temporary table, for example tblTemp update in the tblDatas the records of the tblTemp that compared appear to exist in the tblDatas and writing in the ACTUAL field of the tblDatas the value of the ACTUAL field of the tblTemp
- append in the tblDatas the records of the tblTemp that compared do not exist in the tblDatas by writing the value 0 in the FORECAST SURGE fields
- delete the tblTemp table.