Child ID Access

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

(more…)

Technorati 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