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

2. Select Folder where files you want to import reside in

3.Click Import

4. Import Successful Message

5. Table created from the files

6. Table includes a field stating the filenames

Download File