You don't need to write code  ( it may be varies according to your requirment)
u can directly link ur Excel into Access
Pls try this Open ur DB(Access)

Goto File>Get Entrenal data>Link table
In this way whenever you make any changes into Excel It will reflect to your
Access DB

Other way, Excel gives you a facility to creat you own table in Excel.
Please read the help  "Name cells in a workbook"
Now you can use ADO to load the data  into Access DB