I'm working on a asp.net 2.0 site with sql, and i use an excel file to upload mass input data to the db, it works fine in w2kserver but in w2k3server i get the following error:

OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by

another user, or you need permission to view its data.]

May be your Excel file is kept open. Close it and try. also try to close anyother programs that open ur excel file. also check ur code if ur excel file is being opened in anyother part of the code and not closed

Guys, I've fixed it, you have to grant security access to the IUSR on the temp folder of aspnet (C:/Documents and Settings/[servername]/aspnet/local settings/temp). actually i grant permissions to everyone but it seems to be something about impersonation on the web.config file, later I'll study this issue, but for now it works for me. Thanks