Refreshing from a Sage multi company setup

[admin]

I am running Windows Vista so please allow for some differences in case you are using Windows XP.

1) Start the Control Panel from the Windows Start menu.
2) Select Classic View on the Control Panel.
3) Select Administrative Tools
4) Select Data Sources (ODBC)
5) Select the tab System DSN

On this tab you will be able to see the Data Source created when Sage was installed. I have Sage 2007 installed on this machine and a predefined Data Source called SageLine50v13.

6) Press Add... from the System DSN tab
7) Select the correct version of Sage. On my machine Sage Line 50 v13.
8) Select Finish.
9) Name the Data Source, e.g. Client 1
10) Type the Path to the Sage Database you wish to use.

You can use the file explorer to find the right "Data Path". In a 1 company Sage setup the database is by default installed in:
C:\Program Files\Sage\Accounts\ACCDATA
If the directory contains a file called ACCDATA.INI you have located the correct path. As another example the default Sage demo database is installed in:
C:\Program Files\Sage\Accounts\DemoData\Accdata

Repeat the above steps for every customer database you wish to refresh from. The ODBC data sources can now be selected from Profit Manager from the Refresh window.