Tutorial: Sage and MSQuery #4 - Add the missing pieces of data. By David Carter
When you bring data out of an accounts package into Excel, key items of data are usually missing. How do you include them? Simple: use Excel's Vlookup function to pull in the extra data from a lookup table. David Carter continues his series on creating an analysis-ready file in Sage Line 50 and Instant.
1. The story so far
In Tutorial 1 we linked up Sage directly to Excel via ODBC.