Click here to Skip to main content
15,064,915 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hello 

i get following error when i export the data in to excel file using OLEDB



The Microsoft Jet database engine cannot open the file 'D:\AspProject\ExportToExcel\Web\UploadFiles'.  It is already opened exclusively by another user, or you need permission to view its data. 


What I have tried:

i get following error when i export the data in to excel file using OLEDB



The Microsoft Jet database engine cannot open the file 'D:\AspProject\ExportToExcel\Web\UploadFiles'.  It is already opened exclusively by another user, or you need permission to view its data. 
Posted
Updated 21-Oct-19 23:18pm

1 solution

Read the error message: it's pretty clear.
Quote:
It is already opened exclusively by another user, or you need permission to view its data.

So either the file is in use somewhere else in your app, or a different app; or the file or part of the folder tree it is in is not available to your user because of permission problems.

Start by checking which user is trying to access the file (the "AspProject" implies web based, so it's probably IIS on your dev machine which is not running under your UserID) and then check the file tree to ensure that the folder and file are read and write accessible to that user.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900