Import & update data to MS Access from Excel Spreadsheet

Hello All,

I've developed a simple program that required to perform import and export activities. This activity is used to gather & console data from multiple branch office. So, HQ office is doing importing activity to gather all data from multiple branch office.

Export process is working fin at branch office; however, I faced one issue where upon importing data to MS Access from excel spreadsheet, it seems the data never get updated/ replace.

beside appending data, my concern here is the import process never cover updating/ replace changed data to MS access table.

wondering, is anyone could assist me by provide guidance in macro or scripting to performance udpate/ replace changed data from external set of data(excel spreadsheet).

Thanks.

rgds,
TaneS