Tutorial: Import Data into Excel from Access Dimensions. Part 1. By David Carter
This is for readers of AccountingWEB who use the Dimensions package from Access Accounting.
There are two main ways of getting data out of Dimensions and into Excel. The first is to set up Dimensions as a SQL Server data source in Windows, then use the Import External Data command to pull the data into Excel.
The second is to use Access Analytics, an extra module supplied by Access. Analytics generates two “analysis-ready files” – one for Sales Analysis and one for General Ledger analysis – and feeds them into an Excel pivot table.