Export specific Excel cells to Access

Hi,
I'm putting together a submission form in excel which will update a database in access.
I'm currently trying to use a macro on the submit button to do it but and while i understand the majority of it im not sure how to establish the connection through the macro.
Essentially im a VBA n00b and haven't completed a project like this before now.
So i guess my question is how would i go about establishing this through an excel based Macro?
This is my code for submitting the data into Access
rs.Open Sql, cn, adOpenDynamic, adLockOptimistic With rs .AddNew .Fields("Date").Value = Trim(Cells(50, 1).Text) .Fields("Agent").Value = Trim(Cells(50, 2).Text) .Fields("Request").Value = Trim(Cells(50, 3).Text) .Fields("Date1").Value = Trim(Cells(50, 4).Text) .Fields("Date2").Value = Trim(Cells(50, 5).Text) .Fields("Start"). ...