Loading

Excel to sql in ASP.NET Web Application

Mufid Bagdadi

10y844.NET

I am trying to extract data from excel sheet to my database table. But when i try to execute there is an sql exception.

The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma10y ago
http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx
Manas Mohapatra10y ago
As per your error it is saying:

1. Please make sure it is not opened by other user.
2. It might need network permission to access the file.

http://www.aspdotnet-suresh.com/2013/01/c-microsoft-office-access-database.html