Access and SAGE

[philcon]

Just a quickie,

Does anyone know if access can pass data to SAGE ?

I have just been offered a tentative project by someone who has general accounts managed by SAGE but wants to implement an order processing system which passes financial data to SAGE. Alternatively does anyone know if SAGE can pull data from access ?

Would be grateful to know if anyone has experience of such work.

Regards


Phil

 

[EnidtheDog]

Yes on both counts Phil.

First, which version of Sage? I do most of my stuff with Line 50...

You can read Sage records in Access using ODBC. You can then export Access data to a csv file and import into Sage.

Or, even better, use the SDO (which comes with V8 of Line 50).

The SDO allows you to read and write to native Sage tables, manipulate Sage data etc. using any VB application...

 

[philcon]

Not sure which version just yet, but I know its just been bought recently.

Thanks for getting back, I am sure I will try and get in touch in the next couple of weeks when things start moving.

Regards

Phil.