Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues.

Note:
He is able to export another SharePoint list with 200 items and also add items.

Error: An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reintsall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor.

share|improve this question
Time to figure out what is different between your machine and his machine. Do you guys have different versions of office? It seems to me like this is an Excel problem.. not a SharePoint problem. – Kit Menke♦ Dec 28 '11 at 15:13
If it is an Excel issue, it should not work for a smaller list right? But, It is working for a list with 100+ items... – Karthikeyan Dec 28 '11 at 18:36
We both are running on Office 2007 on Win7.. – Karthikeyan Dec 28 '11 at 18:36

2 Answers

up vote 3 down vote

Open the SharePoint 2010 Central Administration, Go to Application Management => Manage Web Applications and then select your web application. In the Ribbon, select the General Settings => Resource Throttling, There you can see the threshold limit 5000, edit the value as you need and save it.

share|improve this answer
I wonder how does it work for myself but not for my colleague. If it is something to do with threshold setting then it should throw the same exception for myself too right? – Karthikeyan Dec 26 '11 at 12:17
also items are stored properly on the separate folders. – Karthikeyan Dec 26 '11 at 12:19
1  
If you are an administrator, you will have a higher threshold than he does. I think the default admin threshold is as high as 20,000 or something like that. – AndrewSwerlick Dec 28 '11 at 17:58
up vote 0 down vote

Try this link out it worked for me. I'm not sure about the trick in it but it worked and I was able to export the list items to excel by following this. I had 4000+ items in my list.

http://www.sharepointserverrecovery.com/blog/troubleshooting-problems-when-exporting-sharepoint-list-data-to-excel-spreadsheet-and-fixing-database-corruption/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.