Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2010
    Posts
    4

    Unanswered: Integrating MS Access with Sage 50 - databases

    Hello Experts,

    I need your help regarding integration of Sage 50 and Microsoft Access as ERP and CRM of the company, respectively.

    My question is: Is it possible/feasible/wise from database point of view to integrate the two systems?

    The scenario would be: Entries will be made on Access database through Access screens and then the data would be loaded into Sage database in real time. Currently the databases of Sage 50 and Access are different.
    I would try to provide other information if it is needed.

    Thank you in advance
    Kind Regards,
    Kanu

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I've done that quite a long time ago but it was with Sage Line 100. As far as I can remember (I'm not in my office at the moment, so I can't check my notes), it was rather straightforward.
    Have a nice day!

  3. #3
    Join Date
    Nov 2010
    Posts
    4
    Hi Sinndho,

    Thanks for the quick reply.
    I think, which may not be correct, that there would be problems in transforming the Access data according to Sage tables in real time. Did you use some other other tool (ETL?) to integrate the two databases or nothing else is required.
    Please help in opening my eyes.

    Thanks
    Kind Regards
    Kanu

  4. #4
    Join Date
    Jun 2011
    Location
    Inside your mind
    Posts
    297
    Read through:

    microsoftaccessdatabase&microsoftexcelin - elliconnon

    Should cover everything you need to know.
    Looking for the perfect beer...

  5. #5
    Join Date
    Nov 2010
    Posts
    4
    Hi kez1304,

    Thanks for this link. Seems lots of information but quite helpful. Will read though it and let you experts know if I get to something.

    Thanks again.
    Kanu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •