Import all excel files in folder to table in Microsoft Access

Have attached an access file which enables one to import all excel files in a folder to Microsoft Access.

The app utilises a simple form design which I borrowed from instructor Steve Bishop's YouTube tutorial

Requirements: All excel files in folder must be structured in a similar format with same headers. 

PS: Data imported to Access will include an additional field which states the respective filename of excel files (source of data)

For situations that requires dealing with multiple file formats ( etc csv and text files), kindly refer to another article : Import files (csv, text and spreadsheet xls) into Microsoft Access

1.Click on Browse

4. Import Successful Message

Download File