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