Hey guys.
So I have a workbook that opens an access database. Via VBA, I need to update two tables in access with values from my workbook.
So the database has two tables, one called "Implementation", one called "Status". My workbook has two sheets, called the same thing, Implementation, and Status. My key between everything is CCID. That field exists in all tables and worksheets. What I need to do is for each CCID that exists in my "Status" worksheet, update the field, "ImpDate" in the "Status" table in access. The same thing goes for "Implementaiton". For each CCID in "Implementation" worksheet, I need to update the "Approval" and "AppDate" fields in the "Implementation" table.
Any ideas on how I would do this? Thank you in advance!
So I have a workbook that opens an access database. Via VBA, I need to update two tables in access with values from my workbook.
So the database has two tables, one called "Implementation", one called "Status". My workbook has two sheets, called the same thing, Implementation, and Status. My key between everything is CCID. That field exists in all tables and worksheets. What I need to do is for each CCID that exists in my "Status" worksheet, update the field, "ImpDate" in the "Status" table in access. The same thing goes for "Implementaiton". For each CCID in "Implementation" worksheet, I need to update the "Approval" and "AppDate" fields in the "Implementation" table.
Any ideas on how I would do this? Thank you in advance!
