i want to insert excel file data to mysql database please help me
my code is:
string ConStr = ConfigurationManager.ConnectionStrings["claimsitesConnectionString"].ToString();
if (FileUpload1.HasFile)
{
try
{
string path = string.Concat(Server.MapPath("~/Files/" + FileUpload1.FileName));
FileUpload1.SaveAs(path);
string Extension = Path.GetExtension(FileUpload1.FileName);
// Connection String to Excel Workbook
string excelConnectionString = "";
switch (Extension)
{
case ".xls": //Excel 97-03
excelConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0", path);
break;
case ".xlsx ...
Go to the complete details ...