So my small company got ourselves into a small problem. We are using the Small Business Premium plan and we had a webApp setup for data collection at remote sites. The lead researcher now needs to get the stored data from the Access web app and put it into Spss and is having trouble using his typical software(which at this time in point I realize I should of asked him what the software was called) to extract the data.
Does anyone have any tips for a process like this or web links with a how to? I haven't worked with an database since 2003, so the new set-up is confusing. Would knowing where the data and how the data is being stored by the webapp help? Any help would be much appreciated!
Edit 1: I tried calling customer service then technical support to no avail. What I've basically came up with in the past 48 hours is that the data is stored in a SQL server or Microsoft Azure SQL database and then uses sharepoint to store this data. I feel like I'm just missing one simple connection to figure this all out.