Greetings,
I need help with adding a command button to a form that will import data from an Excel file into a table. I am not a programmer at all and really need help. I have created an Overtime Hours table and need to add a command button to the form that will import the Overtime Hours Excel file into the table. So each week when I receive the Overtime spreadsheet from HR, I would like to click an Import button on my form that will pull the data from the spreadsheet into the existing Overtime Hours table.
I need help with adding a command button to a form that will import data from an Excel file into a table. I am not a programmer at all and really need help. I have created an Overtime Hours table and need to add a command button to the form that will import the Overtime Hours Excel file into the table. So each week when I receive the Overtime spreadsheet from HR, I would like to click an Import button on my form that will pull the data from the spreadsheet into the existing Overtime Hours table.