Re: Sage Export



Hi

The database used within the Sage Line 50 range of products is
proprietary. Althought I believe the Payroll module uses an MSAccess
database.

To access the customer/supplier addresses we use the ODBC Driver which
comes with the Product but this cannot be used for posting into the
accounts. Reluctantly we had to sign up for their developers program to
have access to the SDO (Sage Data Objects) which is an ActiveX which
allows two way access to the various data files. Unfortunately if you
are likely to need any Delphi specific help their support staff are
very much VB orientated as are the help files provided. Fortunately I
have been able to work out most things myself so this has not been a
problem.

We found the SDO to be very slow when access more than a few hundred
records across a network so we always use the ODBC Driver to access
data and only use SDO for posting Invoices etc..

Hope this helps

Stuart
GSD Associates Ltd.

--

.



Relevant Pages

  • Re: Sage Export
    ... The database used within the Sage Line 50 range of products is ... To access the customer/supplier addresses we use the ODBC ... data and only use SDO for posting Invoices etc.. ... Does Sage have batch processing within the GUI for importing CSV / XML / EDI ...
    (borland.public.delphi.thirdpartytools.general)
  • Connecting to sage line 50
    ... apps, asp sites etc. ... But this is not my profession, ... and job section of that database by linking it to mdb. ... There seems to be very little support for sage. ...
    (microsoft.public.access.externaldata)
  • Re: Sage Line 100
    ... Access to the database is not a problem, but avoid to use the cbase format from Sage. ... Then it's a standard MS SQL Server database. ... Can anyone confirm this or does any one know of any resource to allow me to integrate without any stupid Dev centre. ...
    (borland.public.delphi.thirdpartytools.general)
  • RE: To Automate an ODBC tables link via a button on switchboard
    ... have you linked the tables from your Sage Line ... database into your ... Create a new Macro, ... >> Colin Auton ...
    (microsoft.public.access.externaldata)
  • RE: To Automate an ODBC tables link via a button on switchboard
    ... have you linked the tables from your Sage Line database into your ... Create a new Macro, ... If you like you can add a SetWarning: Yes at the end of the Macro. ...
    (microsoft.public.access.externaldata)