Import the data from EXcel

[abdullahsikandar]

Hi Guys,

I have a button in Access Database, but i don`t have a functionality.

I need whenever i press "Import Button" it will automatically open the filer and i will navigate to select multiple files of excel anywhere in my hard drive.

when i import the data it will automatically import all the data into the table of the database.

Overview: Whenever i press the button, then we have to select the multiple files of excel sheet from sheet1 then it will automatically append all the excel sheets into database.

 

[TerryHogarth21]

All that you'll ever need for importing Excel in Access
EXCEL Import