I am currently new to using MS Access with 0 experience. I have a pretty complex pivot table in excel with 28 columns and around 60 rows that feeds into another table where we use the Getpivotdata formula to pull data from the pivot into a new table which resides in excel. I want to recreate this by importing the raw pivot table data in MS Access and then utilize and apply something similar to getpivotdata to populate fields in a new table on access. Does anyone have any advice on how I can do something similar to getpivotdata?