Loading

uploading excelsheet into db (sql server 2008)using asp.net

ancy chacko

i want to uploading excel sheet into sql server2008 using asp.net 2010
i got one error
"The Microsoft Office 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.

ancy chacko11y ago
Hi
Thank you
I have problem in that excel sheet uploading...
I was uploaded that excel sheet successfully....but again i want to upload that excel sheet .... the data will repeating ....
How to stop that repeating and i want to delete the exsisting data and upload new excel sheet in db sql server 2008 usong asp.net 2010
Dipankar Biswas11y ago
See this link..

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