Importing Transactions Using Power of MS Query

By BAASS Consultant | Mar 5, 2010 12:00:00 AM

Sometimes one doesn't have to exit an Excel spreadsheet to get the necessary data, all Sage 300 (formerly Accpac) tables can be accessed and analysed directly from within Excel. Yes, yes - Excel! I'm talking here about MS Query that can be called upon from the Data menu of Excel. Provided you know the ODBC connections to your company's data and credentials to access it you're good to go and query the data you need, all fields of any table, with selections and filters are available. Of course knowing SQL language can be handy and can save hours of work, as in the below example.

Read More >