Switch to the "External Data" tab in Access and locate the "Import & Link" group. Click on the "Excel" option. The "Get External Data – Excel Spreadsheet" dialog box opens.

Microsoft Excel and Microsoft Access both store data used to write a financial report. However, Excel has more built-in options for quickly generating a report from a small amount of financial data.

In this way, you can allow multiple users to access data while limiting the data each can edit. I’m using Microsoft 365 , but you can use earlier versions of Excel. Excel for the web supports ...

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.