Sage Construction & Real Estate

Does Sage 300 have an active integration with Microsoft Access, or is it a manual process? Which users rights are necessary to modify the integration, and change what is sent from Sage 300 to MS Access?

Do you know how to link a Sage 300 CRE report with a Microsoft Access table that indexes states and cities to counties? I have a need to print revenue by State, County and City. Because I can’t find where Sage 300 CRE has a table that indexes states and…