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.
Well look at Analytics in the next article. But for users who dont have Analytics, in this first tutorial well set up Dimensions as a data source in Windows and import from the data tables into Excel.
Before we start, a note of caution. SQL Server is a com...