Import Excel Sheet in sql ser 2008 database

Question

1.00/5 (1 vote)

See more:

Hello Professional

there is a case where i need to import data from Excel sheet to Sql server 2008 data base
i tried on google also got so closed coding structures also implemented but still its need to troubleshoot.

still the exception that is occurring is :-The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

and one thing that is really you need to aware that i am using Microsoft Enterprise Library
in ma project...

any appreciation is welcomed but without other website's link (specially if you yourself not practiced on that)...

Thanks in Advance

Posted 27-Nov-13 19:16pm

Shubh Agrahari

Add a Solution

Comments

Maciej Los 28-Nov-13 2:08am

Share your code. Without it we can't help you.

Shubh Agrahari 28-Nov-13 3:00am

string connString = "";
//string FileName = Path.GetFileName();
string strFileType = Path.GetExtension(fileuploadExcel.FileName).ToLower();
//string path = fileuploadExcel.PostedFile.FileName;
string path = Server.MapPath(fileuploadExcel.FileName);
var fileName = string.Format("{0}\\" + path + "", Directory.GetCurrentDirectory());
//Connection String to Excel Workbook
if (strFileType.Trim() == ".xls")
{
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (strFileType.Trim() == ".xlsx")
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
string query1 = "select [AppliedDistrictName],[ChalanNo],[MobileNoForApp],[ApplicantName],[FatherName],[MobileNo],[PermDistrict],[TempDistrict] from [Sheet1$]";
string query = "SELECT * FROM [" + path + "$]";
OleDbConnection conn = new OleDbConnection(connString);
if (conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand(query1, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();

da.Fill(ds);
grvExcelData.DataSource = ds.Tables[0];
grvExcelData.DataBind();
da.Dispose();
conn.Close();
conn.Dispose();

3 solutions

Solution 1

Hi! See this Article. I hope it will help you. Thank You.

Posted 27-Nov-13 19:44pm

Debopam Pal

Solution 2

i had a same error before couple of days...

Please Make sure that path you are passing is the same path from were you are browse the file...

Posted 28-Nov-13 3:02am

Rahul JR

v2

Comments

Shubh Agrahari 29-Nov-13 6:45am

Thanks buddy i done it with some troubleshoot

Rahul JR 29-Nov-13 6:59am

welcome..

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shubh Agrahari · Accepted Answer · 2013-11-29T01:23:00

Solution 3

Thanks to you all and all your opinions.........

i solved it myselfy

Posted 29-Nov-13 1:23am

Shubh Agrahari

Comments

Nelek 29-Nov-13 7:36am

You should use the "improve solution" and add more information about how did you solve it, it can help other people having similar problems in the future.