Implementing pervasive SQL pivot table for MS Excel queries

Asked By fern bonnie 30 points N/A Posted on - 12/07/2012

How does one implement pervasive sql pivot table for MS Excel queries in order to ensure a cross-performance of data mining across the excel and database?

 

• Status: Open
• Question Views: 1185
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By May Jratr 0 points N/A #147421

Implementing pervasive SQL pivot table for MS Excel queries

Hello Fern Bonnie ,

Hope that my message finds you well.

Follow the below steps:

–       Click the open door icon to see the “Import Data”.

–       Select the range that you want from your Excel sheet.

–       The Microsoft Excel give you a lot of features to work with excel reports.

–       Also you can change the parameters as shown below.

–       You can use the query with PivotTable, choose from the menu file then open the query that you just created to use it with PivotTables.

Hope this solution will help.

Kind regards,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/15/2012
• Question Category: Misc Databases