Click here to Skip to main content
15,891,529 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
strConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["a"].ToString();
//file upload path
//string path = fileupload1.PostedFile.FileName;

fileupload1.SaveAs(Server.MapPath("~/excel/" + fileupload1.FileName));
string a = "~/excel/" + fileupload1.FileName;
//Create connection string to Excel work book
string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='a';Extended Properties=Excel 8.0 Xml;HDR=YES;";


//Create Connection to Excel work book
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);

//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand("Select [ID],[Name],[Designation] from [Sheet1$]", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);

//Give your Destination table name
sqlBulk.DestinationTableName = "Excel_table";
sqlBulk.WriteToServer(dReader);
excelConnection.Close();


[edit]Code block added - OriginalGriff[/edit]
Posted
Updated 27-Mar-13 22:16pm
v2
Comments
Richard C Bishop 28-Mar-13 17:56pm    
The problem comes from your excelConnectionString. You need to removed the "Xml" after the "8.0" in the Extended Properties.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900