With Microsoft’s recent announcement of them pulling the plug on Acess Web Apps (AWAs) (this is NO way impacts the future of standard MS Access Desktop databases), see:
http://www.devhut.net/2017/03/27/steer-clear-of-access-web-applications-awa/
the question has become about how one can salvage the data from an AWA. What means can we employ to export the tables so we don’t loose all our data.
Thankfully, George Hepworth has put together a very valuable tutorial on the subject:
Get Your Data From Your Expiring Access Web App
In his article, George presents 3 different possible ways to extract your Acess Web Apps (AWA) data:
- Convert To Local Tables in Access
- Create SharePoint Lists from your SQL Azure Tables
- Deploy a dacpac (for SQL Server 2008 R2+)
So if you are looking for information on how to extract your raw data from your AWA, please take a look at his article!