With Power Query in Excel 365, you can do just that. This powerful tool allows you to merge files from a folder into a single dataset, automatically updating as new files are added.

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.

We show you how to import data from Access Data Database into Micrsoft Excel. Access is the primary tool for managing a database.