VB Code to export data from excel to Access

Hello:

Please refer to attached file.
I need a VB Code to export certain data from excel to MS Access.
Below is my requirement

Sheet from where data is to be extracted to be exported : EmpHours
Data Range A5 to End of month (in this case look for last day of month 11/30/2015)


Name of Access File Test1.accdb
Location C:\Temp\ ' This will be the same path as the excel file.
Table Name : EmpHour


Let me know if you have any questions.
Thanks.

Hello:

I am trying to use below code which i got from Google but for some reason it is erroring out at 3rd column.
Please help to find and resolve the problem.

Note : I am re-attaching the excel file with the code.

Thanks

Please Login or Register  to view this content.