About 400 results
Open links in new tab
  1. Move data from Excel to Access - Microsoft Support

    This article shows you how to move your data from Excel to Access and convert your data to relational tables so that you can use Microsoft Excel and Access together.

  2. Import or link to data in an Excel workbook - Microsoft Support

    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.

  3. 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.

  4. ImportExportSpreadsheet Macro Action - Microsoft Support

    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 …

  5. Tutorial: Import Data into Excel, and Create a Data Model

    When you import tables from a database, the existing database relationships between those tables is used to create the Data Model in Excel. The Data Model is transparent in Excel, but …

  6. 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 …

  7. Import database objects into the current Access database

    Learn how to import objects from one Access database into the current Access database.

  8. Video: Copy data from Excel - Microsoft Support

    Training: Copy data from an Excel spreadsheet. Then in Access, paste the data into an existing table or a new one. Watch how in this online training video.

  9. 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.

  10. Export data to Excel - Microsoft Support

    Excel includes a command to import data from an Access database. You can use that command instead of the export command in Access; however, the Excel import command only allows …