The best solution is to use Access, where you can easily import and append data into one table by using the Import Spreadsheet Wizard. Furthermore, you can append a lot of data into one table. You can save the import operations, add them as scheduled Microsoft Outlook tasks, and even use macros to automate the process.

You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into a new or existing table, or link to a worksheet from an Access database. This topic explains in detail how to import or link to Excel data from Access desktop databases.

Import database objects into the current Access database. Import or link to data in an Excel workbook. Import or link to data in an SQL Server database. Link to or import data from an Azure SQL Server Database - Access 2016 and newer versions only. Import or link to data in a text file. Import or link to data in a SharePoint list. Link to or ...

In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share. The tutorials in this series are the following: Import Data …

You can import tables, queries, forms, reports, macros, or modules from one Access database into your current database. When you import an object, Access creates a copy of the object in the current database.

Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.

You can use the ImportExportSpreadsheet macro action to import or export data between the current Access database (.mdb or .accdb) and a spreadsheet file. You can also link the data in an Excel spreadsheet to the current Access database.

Take advantage of the streamlined editing, powerful querying, and helpful reporting capabilities in Access by copying data from an Excel spreadsheet. Put your data into an existing table or into a new, blank table.

You can bring data from one Access database into another in many ways. Copying and pasting is the simplest method, but importing and linking offer you better control and flexibility over the data that you bring, and over how you bring that data into the destination database.

In Access, when you import, you bring data into Access once, but without a permanent data connection. When you import data, Access stores the data in a new or existing table without altering the data in Excel.