Dear Access Expert,
I'm seeking help in updating and appending data from Excel to MS Access table.
As i was trying to perform consolidation process in MS Access by using import and export function. Which allow me to gather data from various branch office and perform console process at HQ office. Hence, Branch office is performed exporting process and HQ office is performed importing process.
By using above approach, my challenge is ensuring data from branch office are updating to HQ level. However, this challenge become part of my concern as because the data set from branch office are included "New record" and as well "updated records" set.
I tried using "TransferSpreadsheet" function in macro but it was only appending new records and not for update existing records.
So, i'm seeking help as anyone could assist me in providing coding or macro to handle above scenario.
Thank you so much in advance.
Best Regards,
Tan eS
I'm seeking help in updating and appending data from Excel to MS Access table.
As i was trying to perform consolidation process in MS Access by using import and export function. Which allow me to gather data from various branch office and perform console process at HQ office. Hence, Branch office is performed exporting process and HQ office is performed importing process.
By using above approach, my challenge is ensuring data from branch office are updating to HQ level. However, this challenge become part of my concern as because the data set from branch office are included "New record" and as well "updated records" set.
I tried using "TransferSpreadsheet" function in macro but it was only appending new records and not for update existing records.
So, i'm seeking help as anyone could assist me in providing coding or macro to handle above scenario.
Thank you so much in advance.
Best Regards,
Tan eS