Excel VBA to update table in Access 2013

Hello

I have an Excel 2013 spreadsheet with multiple tables (1 table in each worksheet).

Each of these tables mirrors the data I have in an Access 2013 database.

The data is duplicated into Access 2013 because there are some Query Reports which are run (due to a few many-to-many relationships between the tables) and subsequently exported to Excel 2013!

I’d like to be able to update one or more of these tables in excel, click a button (one button per table) and then for the data to be updated in the Access 2013 table.

I’ve thought about the best way of doing this & I think the simplest method would be for the VBA code to open the table in the Access 2013 database, delete all of the records (but keeping the column headers), and then import all of the rows from the Excel table.

This would ensure that the tables in Access 2013 fully mirror the tables in Excel 2013 whilst leaving the relationships between the tables intact.

Does anyone have any sample code which I could perhaps tweak?

Thanks in advance

Thanks Arkadi, i'll work with your code & post back how i get on.

Thanks for the tip Alan

I would have preferred to link the Excel worksheets to Access but unfortunately i've had issues creating the right relationships between the tables once they've been imported (probably because my data is structured in the way Access would like it).

However, i already have an Access database with the correct relationships between the tables but it just needs to be updated.

It's weird that i'm not using what should be the simpler approach but it's most probably because of my lack of knowledge of Access (sorry!)