Access database update sage

I have built an access database system for a customer that records work history etc, they also want a button that updates sage.

Anyone know how I go about this???
Who is Participating?
nico5038Connect With a Mentor Commented:
I'm afraid you'll have to contact Sage for that as all their website reveals regarding office is:
Sage Line 50 Financial Controller (single user and network multi-user) can be linked with Microsoft Office.

This means that you may read data straight into Excel, Word or Access from Sage Line 50 Accountant using the Sage ODBC data driver provided. If you do not buy the Sage Line 50 Financial Controller product you can still export data in CSV file format from Sage Line 50 Accountant or Accountant Plus that can then be opened in Word, Excel etc.


So "read-only"
Only when there's an Import possibility you'll be able to pass information into their database.
Most applications however won't allow outside applications to edit the data as it might ruin the consistency....

Steve BinkCommented:
What is sage?
DP1975Author Commented:
Sage accountancy software
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Sage is a seperate piece of s/w, you will need to find out if there is anything out there which allows you to communicate with that database, hopefully one exists for VB to use, someone may have written an OCX

Hopefully somebody here knows else you might wanna do a search on google or something
i admittedly don't know sage, and 'update' can mean a lot of things (you might want to post details about it), but i would start by investigating whether sage provides an ODBC interface and/or whether it's possible to call sage using command line parameters and/or some sort of batch file.

Just had a look at the website (I think this is theirs)

so it must be possible to create addons

maybe its worth contacting Sage themselves to see what SDK's they might have available
Steve BinkCommented:
I did a quick search on google for "Sage ODBC", and got plenty of references.  Not being familiar with the software, I would not trust myself to make a recommendation on any of the drivers I saw.  I'm sure you'll be able to locate one out there that suits your needs, and they are generally pretty simple to install.

I did the same thing awhile back with Access, AS/400, and MAS90.  It was a reconciliation routine to compare a database inventory against running bank transactions.  The project did not call for updating the internal db of the accounting software (MAS90), only drawing reports from the data, and good thing since it did not truly support external updates.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.