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.

Open the Excel workbook, make sure each column has a heading and a consistent data type, and then select the range of data. Select External Data > New Data Source > From File > Excel.

You can import data from an Excel worksheet, from a table in another Access database, from a SharePoint list, or from a variety of other sources. The process you use differs slightly, …

Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.

When you open an Excel workbook in Access (in the File Open dialog box, change the Files of Type list box to Microsoft Excel, and select the file you want), Access creates a blank …

At this point, you might want to import or link your worksheet into Access and use it as a database instead of working with it in Excel. Or, perhaps you have data in an Access database for which …

To do this, create a connection in Excel, often stored in an Office Data Connection file (.odc), to the Access database and retrieve all of the data from a table or query.

You can create an app either from a template or from scratch. To create a custom Access app: Open Access 2013 or later and click Custom web app. Enter a name and the server location …

Using the Export Wizard, you can export data from an Access database to in a file format that can be read by Excel. This article shows you how to prepare and export your data to Excel, and …

You can create a table by creating a new database, by inserting a table into an existing database, or by importing or linking to a table from another data source — such as a Microsoft Excel …