Tutorial: MS Query and Sage #2 - import balances into Excel. By David Carter

Following his first tutorial on how to set up MS Query and the Sage ODBC drivers, David Carter's second tutorial shows you how to extract monthly nominal account balances from Sage and import them into Excel.

We’ll start with a simple exercise to help you find your way round MS Query.

Sage offers numerous Trial Balance and P&L reports. But you can only print a TB or P&L for a single period. Often managers like to see the figures for several months side by side, which gives an idea of trends.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Sage200

alisonv19 | | Permalink

Hi

 

I have worked with sage 1000 for many years and kow most of the tables to use for most of the modules.

 

I have now moved jobs and using sage200 and the table structure is totaly different. Could you le me know how i would get a stock history information out from sage 200 as this was relativly easy in sage1000 as most of the data was in the stkhstm table.