OleDbExecption in MVC4

Question

I have a code which can download an excel file and it will select all of its data in side. Here is my code:

string conn = string.Empty;
            if (Path.GetExtension(path).ToLower().Equals(".xls"))
            {
                conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
                                + path +
                                ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
            }
            else
            {
                conn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
                              + path +
                              ";Extended Properties=\"Excel 12.0;HDR=YES;\"";
            }

            string strselect = "Select * from [Sheet1$]";

            using (OleDbConnection excelCon = new OleDbConnection(conn))
            {
                try
                {
                    excelCon.Open();
                    using (OleDbDataAdapter exDA = new OleDbDataAdapter(strselect, excelCon))
                    {
                        exDA.Fill(_data);
                    }
                }
                catch (OleDbException oledb)
                {
                    throw new Exception(oledb.Message.ToString());
                }
                finally
                {
                    excelCon.Close();
                }
            }

when I debugged it, in excelCon.Open(); I get transferred in my Catch and get an OleDbException: "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."

Can you point out what's wrong? I don't have an opened file and I checked its settings but it can be opened by anyone. Any one of you experience this kind of error?

the excel file is already opened by someone and you can;t access it — Ehsan Sajjad, Apr 14 '14 at 05:33
what should I do about this? and who is opening it? I don't really opened the file. :/ — Ms. B, Apr 14 '14 at 05:35
it is being used by some process in the system, the error says all — Ehsan Sajjad, Apr 14 '14 at 05:41
well yes, it is opened to get the data inside, but what should I do about it? — Ms. B, Apr 14 '14 at 05:50
you open it to get and and do close after after doing whatever you want to do, otherwise you will get this exception every time — Ehsan Sajjad, Apr 14 '14 at 05:51
I tried debugging it again but I only see one instance well it will select or open the file. :/ Are there any other solution for this? — Ms. B, Apr 14 '14 at 05:55
http://stackoverflow.com/questions/3846646/exception-in-opening-a-file-that-is-already-open — Ehsan Sajjad, Apr 14 '14 at 05:57
well to take note: the code I posted is for Uploading the file. So I am just trying to upload it first before I select the items. — Ms. B, Apr 14 '14 at 06:03

OleDbExecption in MVC4

0 Answers0