VBA help needed to locate the excel workbook then import data into a table

Hi Folks,

I have database contains an user form called “MainForm” and table called “JobList”. In the MainForm I have placed two buttons (named “Import Joblist” and “Refresh Joblist”) and one textbox (named “Text1”)
Now I need a macro for “Import Joblist” button to locate the excel workbook then import records set into the table called “JobList” AND show the Folder Path and excel workbook name in the “Text1”. I have some existing code to locate the folder and excel workbook and show the folder path and file name in “Text1” - its working fine). But I don’t know how to write a code to import data from selected excel file.

Now I need one more macro for “Refresh Joblist” button to locate a excel workbook based on “Text1” value folder path then import records set into the table “JobList”.

I have attached the Database and excel workbook of what I am trying to accomplish.

Thanks in advance,

Joshi