All geek questions in one place

How to use Access database with query as pivot table in Excel

I want to use an Access database with a query for a pivot table in Excel.

How to do it?

+3
source share
1 answer

Open Excel and select Data-> Pivot Table ....-> External Data Source-> Get Data. Then select Microsoft Access MDB and find the MDB file. Select the appropriate tables and / or queries and fields.

+1
source

Source: https://habr.com/ru/post/1735500/

More articles:


All Articles