Import or link to data in a text file - Microsoft Support
You can first export the source data as a text file and then import the contents of the text file into an Access table. You use Access to manage your data, but you regularly receive data in text …
Introduction to importing, linking, and exporting data in Access
This article shows you what kinds of data you can import, link to, and export from Access.
ImportExportText Macro Action - Microsoft Support
You can use the ImportExportText macro action to import or export text between the current Access database (.mdb or .accdb) and a text file. You can also link the data in a text file to the …
Import database objects into the current Access database
Learn how to import objects from one Access database into the current Access database.
Import or link to data in another Access database
Learn how to import data or link to data from one Access desktop database to another Access desktop database.
Use the Data Connection Wizard to import data into Visio
You can also import Excel worksheets, Access tables or queries, and SharePoint lists directly into a file without using a connection file. For more information, see Import data from Excel, SQL …
Import data from a folder with multiple files (Power Query)
Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.
Move data from Excel to Access - Microsoft Support
Learn how to move your data from Excel to Access and convert your data to relational tables.
Import data from data sources (Power Query) - Microsoft Support
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.
Import or link to contacts from an Outlook address book
When the wizard finishes, Access imports the text file. For more detailed instructions on how to import data into Access from text files, see Import or link to data in a text file.