Further tutorials are listed below for non-Sage users. Tutorial 1: Using MS Query to get Sage data into Excel Microsoft Query only works with packages that are ODBC-enabled. First you will need to ...

Welcome to this short Data Warehouse tutorial. Here we will create a few data sources and centralize that data in the Data Warehouse. We will also make a simple report from the data with PowerBI. The ...

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 ...

Excel spreadsheets are fantastic bits of kit, but databases are not. Rather than making the full jump to replacing Excel with a database system, there is a halfway house you can consider.

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...

To open the SQL .BAK files in Excel, locate the .bak file on your hard drive, right-click it and select & rename it with XLS file extension.