Basically what I am trying to do is take a range of data from a defined Range
on an excel sheet and import that into a table already set up in a Access
Database.

From reading some details on this I understand that an ADO Connection is the
way to go. My problem now is understanding what I need to write as my VBA
code to do this.

Can anyone help?