ExcelSheet Data to Transfer to Access Table Via Userform Command Button…

[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

[Welshgasman]

Have you EVEN tried to walk through the code? , as oSelect is commented out and not even declared?

You should have Option Explicit at the top of every module, Excel or Access

All there is in the zip is the excel file, so not much good to anyone as I cannot walk through the code either?

Edit:
Why not just use the TransferSpreadSheet command?

https://docs.microsoft.com/en-us/off...ferspreadsheet

[ssanfu]

@RAJESHKUMAR

In case you don't know about debugging code, maybe this will help you.
See Debugging VBA Code for methods for debugging VBA code.

[RAJESHKUMAR R]

Dear Welshgasman & ssanfu,

Thanks for your Input, I shall work based on your Input and try to figure out a way to fix my subjected Issue…

Thanks & Regards,
Rajeshkumar R