Forum Discussion
Converting Access Web App data to Sharepoint List
Hello,
We've been using an Access Web App to track timesheet data through SharePoint online 2013. Now that the Access Web Apps are being retired, we are trying to migrate to PowerApps and use SharePoint lists. Most of our data from the web app exported to a SharePoint list without issue, but our largest database (+26000 records) takes 3 days to export, and once it stops, the data is corrupted.
Anyone have any ideas on how to get such a large amount of data exported into the SharePoint list?
13 Replies
- Russell GoveIron Contributor
can you pull the data into a desktop accessdb, add indices, and the upload to a new sharepoint site?
- How are you doing the migration? The problem you have with the largest database is that you might be falling into the classical list threshold in SPO lists
- Malinda ChanyiCopper Contributor
We are using PowerApps - exporting the database into Sharepoint Lists.
- Heiko WatzIron Contributor
We are also using access apps.
But in my tenant I have an option to export my application to a set of SharePoint lists:
It creates a subsite with a few lists.
Do you have this option also?