Forum Discussion
Can you export an Access Web App to SharePoint multiple times?
Hi Paal and Peter,
You're correct that you should be able to export your Access web app tables to SharePoint lists multiple times using the newer export option available from the web browser interface. There's no restriction as far as I'm aware that you can only export once. Think of it terms of a regular Access desktop database. You can easily export the data from an Access desktop database to a different data source multiple times so in the same fashion, you can export your Access web app tables to SharePoint lists multiple times.
Hope that helps,
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
Senior Content Publishing ManagerModern Assistance and Support Experience
Microsoft Corporation
I have the same question and am somewhat surprised to see that a presumably simple yes or no question is yet to be answered by a Microsoft rep..?
Despite having observed a great deal of negative feedback to Microsoft's announcement about retiring Access Web Apps, I try to keep an open mind and read up on the capabilities of PowerApps which is suggested by Microsoft as replacement for AWA.
However, it would be nice to know how to go at it for real, i.e. make an app with PowerApps that connects to (a copy of) our existing data.
So what happens if I export all my database tables to a SharePoint list? Will the SP lists just be "dead" copies of the AWA data at the point of exporting?
Can I export the data to SP lists now, build myself an App for testing and then later, when the app is ready to be rolled out to my users, export the AWA data again, i.e. either over-writing the old SP lists or simply de-connecting the app from the old data and reconnect to the new and up-to-date data?
Thanks