What is the best way to access the Sage 300 CRE database via Excel? I do not have Office Connector

I would like to access Sage 300 CRE data via Excel. I do not have Office Connector, and I am not an IT wiz, but know my way around Excel.  I tried to setup an ODBC connection but could not make it work.  Someone said that there was a MS 365 solution?  What are my options?  I need to keep this simple (I only work with this program 2 days/week, and have lots of other work to do), so this project cannot require a huge investment in time.  We are a small company, so expensive solutions are not an option.  We do not use the full program but rely on Sage 300 CRE for our accounting system (GK/AR/AP/JC/CM/BL/PR).  I find the standard reports in Sage 300 CRE quite useless and, while I have created simple reports and made simple modifications in Report Designer I find this program difficult to use for anything complicated.  I need more flexibility.  I do not know or have Crystal Reports, nor do I want to.  Thanks for your assistance

Parents
  • 0

    Crystal is a reasonable solution, but so is Excel. You should be able to connect with an ODBC connection, as it looks like you have attempted. Basically the process is as follows:

    Install 32bit Excel

    Setup Timberline Data Source (or whatever you name this in 32 bit ODBC Administrator).

    Open Excel

    Connect to data source

Reply
  • 0

    Crystal is a reasonable solution, but so is Excel. You should be able to connect with an ODBC connection, as it looks like you have attempted. Basically the process is as follows:

    Install 32bit Excel

    Setup Timberline Data Source (or whatever you name this in 32 bit ODBC Administrator).

    Open Excel

    Connect to data source

Children