How to Merge Tables From Multiple Excel Files Using MS Access

Buy Me a Coffee? paypal.me/jiejenn/5
Your donation will help me to make more tutorial videos!

Access makes a great tool to perform tasks that are difficult to do in Excel. For example, trying to merge tables from different Excel files and output them into one single Excel file is a nightmare when you have to copy paste one Excel file at a time.

In this tutorial, I am going to show an example how to use MS Access to merge different Excel files into one master table without using VBA.

Visit my website
LearnDataAnalysis.org

My Gears (These are Amazon affiliate links. Would appreciate if you use my link to purchase something so I can earn few bucks toward funding my travel and tutorial equipment as I will be
teaching full-time on YouTube. These are the accessories I personally recommend to boost your
productivity)

Microsoft Surface Go 128GB 8GB RAM (really convenient to carrying around when I go out)
amazon.com/gp/product/B07MGZ4DT6/ref=as_li_qf_a…

Logitech MX Master 2S Wireless Mouse (Primary. Highly recommended if you use spreadsheet everyday)
amazon.com/gp/product/B071YZJ1G1/ref=as_li_qf_a…

Logitech MX Anywhere 2S Wireless Mouse (Backup mouse. Great for travel)
amazon.com/gp/product/B071VK5KXN/ref=as_li_qf_a…

Logitech Craft Advanced Wireless Keyboard (Really enjoy the ability to customize my own shortcuts and the feel of each keystroke)
amazon.com/gp/product/B0768LTVCQ/ref=as_li_qf_a…