I have a follow up question regarding this solution: Exporting item list version history
I used this method and it worked on a very small list, maybe 10 items.
I tried the same method on a large list, 4000 items and I get and error:
Error Cannot complete this action.
Please try again.
Troubleshoot issues with Microsoft SharePoint Foundation.
I don't have powershell access so I'm looking for any other suggested solutions. Perhaps using MS Access? or simply figuring out why the solution above works for small lists and not large lists, even when the view is limited to only 100 items.
EDIT 1: Upon further investigation, it appears to be a limit based on the number of columns in the SharePoint list. Not the columns in the view, but total columns in the list. I've tried the method on a list with 1000+ items but only 4 columns, this worked without any issue. My understanding is that the XML Version history option only works on lists with fewer than 30 columns. I also believe this includes the default columns that are pre-populated by SharePoint depending on the type of list you created.
I'm going to test this in about 10 days when I am able to delete some columns from the list I am working with. If it works, I will report back.