Transfer Data from MS Excel Worksheet To Append it into MS Access Table

[Rajeshkumar R]

Dear Friends,

I have a Folder Named As “Kitting” Insider the Folder

1. There is an Excel File Named As” Material Receipts & Issuance Tracking” available below attachment as well

2. There is an Access File Named As”Kitting_Database”

In Excel Workbook “Database” Worksheet There are 18 Columns different data’s are available…

Similar table available in my access file as well, the name of the table is “HISTORY”

In Excel “UserForm1”… Please Refer “CommandButton1 (Caption : “Transfer To Database”) There are coding to transfer the excel data into access “HISTORY” Table… which is not working and I unable to fix it as well…

Could you please suggest me to clear those codes…?

Thanks & regards,
Rajeshkumar R

[Rajeshkumar R]

Dear Friends,

Is there any additional Input Required from my side to support on my above Request?

Thanks & Regards,
Rajeshkumar R