Display data from multiple sources in a single Data View(转office.Microsoft)
时间: 2024-06-02 19:12:27 浏览: 9
To display data from multiple sources in a single Data View, follow these steps:
1. Open Microsoft Access and create a new blank database.
2. Click on the "External Data" tab in the ribbon and select "New Data Source".
3. Select the type of data source you want to add (e.g. Excel, SharePoint, SQL Server, etc.) and follow the prompts to connect to your data.
4. Repeat step 3 for each additional data source you want to add.
5. Click on the "Create" tab in the ribbon and select "Data View".
6. In the "Data View" tab, click on the "Add Existing Fields" button.
7. Select the tables or queries from each data source that you want to include in the Data View.
8. Drag and drop the fields you want to display from each table or query onto the Data View design surface.
9. Arrange and format the fields as desired.
10. Save the Data View and give it a name.
Your Data View will now display data from all of the sources you added. You can also add filters, sort orders, and calculated fields to the Data View to further customize it.