Inserting Excel File Records Into SQL Server Database Using ASP.Net C#

The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$' is not a local object, check your network connection or contact the server administrator.

The path is not of a legal form error

Hi Mr Vithal, i have error message "could not find installable isam." please help

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.' what was the solution

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.

'No Value given for one or more parameters' please help

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.

This code is very helpful and my requirement is sql table should not take duplicate id while importing csv to sql

I wrote the code exactly what you write but my excel file is not imported in the database. Can you tell me why this is happening ?

How to fix: 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.

Amazing article Vithal. I have one question, can we upload data to multiple tables using single excel file. Like in above case you are inserting to single table. I want something like id, name and address goes to one table whereas designation and id goes to another table. Can we do that??

Getting the error like Invalid operation exception at Econ.Open and The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Use string CurrentFilePath = Path.GetFileName(FileUpload1.PostedFile.FileName); string excelPath = Server.MapPath("~/Files/") + CurrentFilePath; FileUpload1.SaveAs(excelPath); InsertExcelRecords(excelPath);

Ignore protected void Button1_Click(object sender, EventArgs e) { string CurrentFilePath = Path.GetFullPath(FileUpload1.PostedFile.FileName); InsertExcelRecords(CurrentFilePath); } and use

Here is the fix which i found.

Pleae..i get this error..The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$' is not a local object, check your network connection or contact the server administrator.

How to check each excel field record before insert to prevent wrong entry in database for example in database id=456 in excel 1456 so i want to check id before insert record in data base using sqlbulk copy excel import

I am geeting this error like this "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".

Hi... I get this error "System.NullReferenceException: Object reference not set to an instance of an object." in this line "sqlconn = ConfigurationManager.ConnectionStrings["con"].ConnectionString; " kindly help.........

Please im getting this error.The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path correctly.

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.

This does not work

Its very good. I don't have column name like id,name. I need read data from excel to sql table without Header or based on column count. please help me.

The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly

The Microsoft Office Access database engine could not find the object 'Sheet$'. Make sure the object exists and that you spell its name and the path name correctly.

The Microsoft Office Access database engine could not find the object 'Employee'. Make sure the object exists and that you spell its name and the path name correctly.

String CurrentFilePath = Path.GetFullPath(ExcelUpload.PostedFile.FileName) <-- in this line m getting thhis error -->Object reference not set to an instance of an object.

If i am using the that "using statement" mentioned above, an error saying ""file upload is a type, which is not valid in the given context""

Yes, I am using the same code.

Yes offcource you need to use it , are you using same code which is preceding article ?

DO i need to use ""using System.Web.UI.WebControls;""?

I have checked the FileUploader id in both aspx and cs files both are same

Check your FileUploader id

"""CS0103 The name 'FileUpload1' does not exist in the current context""", please let me know why am i getting this error

Welcome

Ok Thanks Sir I got the Solution

Yes you need to change as per excel file extension .

Ok,Sir this I understood,now If I want to upload xls file then will this work or do I need to change the provider From Microsoft.ACE.OLEDB.12.0 to Microsoft.JET.OLEDB.8.0,please do let me know about it,I am confused upon this

Its Excel sheet name , one excel file contains multiple sheets .

What is Sheet1$ used for did not understood,please do let me know about it

Hi varsha desai install Microsoft.ACE.OLEDB.12.0 on your machine , its missing

Hi, Iam Getting an Error (The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine), How to fix this, Please help me

Hi, Iam Getting an Error (The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine), How to fix this, Please help me

welcome

thank you its help me. keep going

Check your file opened in background using task manager and close the all that file related process

My error is : 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. . can you please help me

why oledb connection in sql?

Riddhi Valecha , Can u explain in detail what you wants

Hi...I also would like to know - If the name of person is unique, then in this case how do I fire an update query ?

Hi, Iam Getting an Error (The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine), How to fix this, Please help me

The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly" I am also getting the same error how to fix it ???????? plz urgent help needed

what is FileUpload1 in context

realy tank you for wonderful effort.

Thanks

Great info. How can I get this to work for a table where 'id' is an auto-incremented field?

What is "Sheet1$" I am getting an error that : "The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly"

check whether the selected excel file for upload is opened in somewhere ,check using task manager and close it

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. pls help me

Hello sir I get this error

veera muthu refer my other articles for same

Priya madam wait my next article

thanku....But i need sql data to excel sheet..give me a solution

Can you tell me, how to achieve the same, if I am not using FileUploadControl. I am using simple HTML + AngularJS + webAPi

Am facing this error: The name 'path' doesnt exist in the current context

check your fileuploader control Id

Please help me on this... Thanks in Advance.

Am facing this error: The name 'FileUpload1' doesnt exist in the current context

thanks Upendra

Sheet1 is your excel file sheet name

Hello Sir, I am getting following error while executing : The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$' is not a local object, check your network connection or contact the server administrator.

nice

thanks

simply superb

its an excel sheet number

what is the 'sheet1$' in the above query

Query = string.Format("Select [Name],[City],[Address],[Designation] FROM [{0}]", "Sheet1$");

Vithal Wadje; Hello sir i have gone thru this and able to insert in database bt my requirement is i have to fetch data from excel and den encrypt the data of one particular column as example consider here it is designation column and den save in database, i have readymade encryption algo for this. How should dis will be done, plz help regarding this.

Ok tahnks!

OK thanks

The other popular mechanism these days is OpenXML which deals with generally .xlsx format. There are numerous nuget packages available for the same, my personal favorite is ClosedXML. I just wanted to share this information via your good article. Thanks Vithal Wadje for penning this down!

Good example mentioned. There are two other ways of eXcel handling. The old way is adding Excel dll i.e., Interop services. This is not suggested approach, as its heavy operation

Your article represents OLEDB mechanism to read via Excel records.

Thanks Michal Habalcik sir

thanks Jitendra Kumar sir

Great tutorial

Nice one..