excel pivot import form access query

in access create query with all column

in excel data tab, import from access

drag columns into box