» Build a Pivot Table after using the Excel Add-In “XL-DBQuery” to Query an Access Database

Build a Pivot Table after using the Excel Add-In “XL-DBQuery” to Query an Access Database

This demonstration by the author of XL-DBQuery Kevin Edwards, shows you how to use the query/sql builder XL-DBQuery to query a Microsoft Access database and then export the query results back into Excel as dynamic, refreshable Excel Pivot Table. Find out more at sbsdevltd.co.uk

Duration : 0:4:31

[youtube Y4zjC2AKcSc]

Tags: Access, add-in, Data, data analysis, Database, Excel, export data, external data, import data, Microsoft, mysql, Oracle, pivot table, pivot table tutorial, pivot tables, pivottable, query, query builder, query data, relational database, SQL, sql builder, sql server, xl-dbquery

This entry was posted on Monday, February 1st, 2010 at 7:10 pm and is filed under access database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Build a Pivot Table after using the Excel Add-In “XL-DBQuery” to Query an Access Database”

pgjr00 Says:
February 1st, 2010 at 7:10 pm
ohh wow! This I …
ohh wow! This I have to have, thank you for sharing
ou81aswell Says:
February 1st, 2010 at 7:10 pm
Selling Excel By …
Selling Excel By The Pound! Love it.

Leave a Reply