Hi All,

I am pretty new to access but kind of good in using excel and VBA.

I have an excel 2010 workbook with 12 sheets and the names of them are maintained such a way that these names are same as table names in access 2010 (contains 12 tables).

I would like to have a VBA code in excel that will update the tables in access 2010 with the values in each spreadsheet. Headers are same for excel and access.

Please let me know if i am not clear in explaining my situation.

Thanks,

Sat.