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.
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.