How can I or is there an SDK to allow me to export specific fields of data that I choose out of Sage into Excel?

So we are currently running Sage 50 Quantum Accounting and we are looking to do some sales and inventory forecasting so we would like to be able to export large amounts of data from Sage 50 into at minimum and Excel spreadsheet, preferably from specific fields that we choose.  We have tried to use the internal reporting features of Sage 50 but have not managed to extract a successful report unless we severely limit the number of items or amount of data we are trying to pull.  Ideally we would either just have an SDK or some 3rd party tool to facilitate this but being that we are a relatively young company and new to Sage we do not even know where to start.  I mean it could be that an SDK is not even what we are looking for much less would really even know how to implement.  Any advice that can help to guide us in the right direction will be greatly appreciated.  Thanks.