Tutorial: Import data from Sage Line 100 into Excel. By David Carter
This tutorial shows you how to import data from Sage Line 100 and into Excel via ODBC. This is the probably the easiest way to get data out of Line 100.
Line 100 uses the Retrieve database (as do early versions of Sage MMS/200. So first you will need to set up the ODBC drivers for Retrieve.
Is ODBC already installed?
If you’re lucky, ODBC was set up automatically when Line 100 was installed on your desktop.
Continued...
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.
Or if you are already registered, login here
I found this really helpful
I found this really helpful and it gave me the result I was after - thank you.
Sage Line 100 clarifications
There are some aspects of this article that will, I suspect, confuse the typical Sage Line 100 user:
* most Line 100 users will be on version 7.6 or earlier, in which case the table names are all different to those mentioned in the article, and the way in which tables are linked is also different
* "the location of data" describes typical paths, but these are relatively unlikely to be correct because most Line 100 users will have their data and other Sage related files stored on a network drive not their local disk
* I'm a bit reluctant to generalise, but it is usually much better to filter in Excel than as the data is being loaded into Excel, with two caveats: Excel 2003 and earlier can only load about 63 000 records; there are some fields which are "indexed" eg typically account numbers, which can be used for filters
Lastly, if you have significant numbers of Line 100 transactions, it is generally better to do a batch transfer into something like Access, and then report from there