Re: Connecting to SAGE

On May 15, 7:03 pm, timmg <tmillsgronin...@xxxxxxxxx> wrote:
On May 15, 9:55 am, franc sutherland <franc.sutherl...@xxxxxxxxxxxxxx>
wrote:

Hi,

I am trying to build a database in Access 2003 which can connect to
information in a SAGE system. Should I use ODBC, and if so, which
driver is required? Is there another way of connecting? Which is
best?

Which Sage? I've had sucess connecting to the Sage Fundraising
products via ODBC. I think they lock down access to read only, but it
was sufficient for the queries I needed to run. Interesting data
model.

I never had the need to connect directly to Peachtree - it's import
export automation is quite sophisticated.

Tim Mills-Groninger

Hi Tim,

Thanks for your reply. It's a basic SAGE account package like Line 50
or Quick Accounts (or something like that).

Where did you get the ODBC drivers from?

Thanks,

Franc.
.

Relevant Pages

  • Re: Need to Export Data From Access into SAGE BusinessWorks Acct. Syst
    ... Have you checked to see if Sage or someone else offers an ODBC ... driver to connect Access & Sage? ... (CSV file with three record types). ...
    (microsoft.public.access.externaldata)
  • 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)
  • Re: Sage Line 100... ADO.Net
    ... Which specific ODBC driver are you using? ... "Andrew Teece" wrote in message ... > I am using SAGE Line 100 v7.5 Soverign edition, ...
    (microsoft.public.data.ado)
  • Re: Connecting to SAGE
    ... information in a SAGE system. ... I've had sucess connecting to the Sage Fundraising ... products via ODBC. ...
    (comp.databases.ms-access)
  • Re: Accessing Sage Accounting data
    ... We are Sage developers and get access to the code/files. ... You cant download them. ... I may well ask Sage the same thing but I wondered if this was a generic ODBC issue that arises with other data sets of different systems.... ...
    (microsoft.public.data.odbc)
Loading