Update Access Table from VBA Excel

I cam across this code to update access table from VBA.

It works fine but this need to have the values supplied on the code.

Please Login or Register  to view this content.

Is it possible to amend the code to have the values from Excel Cells say Range A1 to A3

Please Login or Register  to view this content.

My actual spreadsheet has 30 columns, so wanted to have the values received from the excel sheet

Also, would be nice if we could avoid to enter the column header on the code

Please Login or Register  to view this content.

as it has 30 columns but vba to automatically get from column 1 to 30