By SCMerging of excel file is common task one can merge excel files manually by copying one file content to other. But we can merge excel files easily with the help of Microsoft Access.
How to Merge Excel files using Access
First open ms access on your computer and in menu and create blank database as shown below images
and type name of your database and click on create. A blank database is created. Now from menu click on External data and from it click on New data source->From file->Excel then click on from file below shown pop up will be displayed on your screen.
choose path of the file you want to merge with another and click on ok and next tick on first row contains column heading checked as shown below and click next and then finish.
Your first table is created and looks like as shown in below image.
Similarly import next excel file you want to merge. But this time you have to click on Append a copy of the record to the table and the table from the drop down.
then click on next and then finish. Your both excel files will be merged and you can export it into excel by clicking on excel icon in External data tab highlighted in blue color in image below
