怎么样将Excel文件导入Sql数据库中的表中？
比如上传一个excel文件，将它插入sql数据表中,再删除它，上传和删除都知道，可是怎么插入数据表？
谁能讲的简洁点？网上有的说的太麻烦了！！拜托了！

------解决方案--------------------
if(file1.PostedFile.FileName!="")
{
try
{
strPath=file1.PostedFile.FileName;
string fileExtName= strPath.Substring(strPath.LastIndexOf(".")+1);
if(fileExtName.Trim()!="xls")
{
this.Response.Write("<script language='javascript'>alert('文件格式不正确')</script>");
return;
}
strMath=Server.MapPath("../Import/");
strName=strPath.Substring(strPath.LastIndexOf("\\")+1);
if(File.Exists(strMath+strName))
File.Delete(strMath+strName);
file1.PostedFile.SaveAs(strMath+strName);
strPathName=strMath+strName;
this.Response.Write("<script language='javascript'>alert('上传成功')</script>");
}
catch
{
this.Response.Write("<script language='javascript'>alert('上传失败')</script>");
try
{
System.Diagnostics.Process[] myProcesses;
myProcesses =System.Diagnostics.Process.GetProcessesByName("excel");
foreach (System.Diagnostics.Process instance in myProcesses)
{
instance.Kill();
}
File.Delete(strPathName);
}
catch
{}
return;
}
}
else
{
Response.Write("<script language='javascript'>alert('请选择需要上传的数据文件')</script>");
return ;
}

------解决方案--------------------
if(file1.PostedFile.FileName!="")
{
try
{
strPath=file1.PostedFile.FileName;
string fileExtName= strPath.Substring(strPath.LastIndexOf(".")+1);
if(fileExtName.Trim()!="xls")
{
this.Response.Write("<script language='javascript'>alert('文件格式不正确')</script>");
return;
}
strMath=Server.MapPath("../Import/");
strName=strPath.Substring(strPath.LastIndexOf("\\")+1);
if(File.Exists(strMath+strName))
File.Delete(strMath+strName);
file1.PostedFile.SaveAs(strMath+strName);
strPathName=strMath+strName;
this.Response.Write("<script language='javascript'>alert('上传成功')</script>");
}
catch
{
this.Response.Write("<script language='javascript'>alert('上传失败')</script>");
try
{
System.Diagnostics.Process[] myProcesses;
myProcesses =System.Diagnostics.Process.GetProcessesByName("excel");
foreach (System.Diagnostics.Process instance in myProcesses)
{
instance.Kill();
}
File.Delete(strPathName);
}
catch
{}
return;
}
}
else
{
Response.Write("<script language='javascript'>alert('请选择需要上传的数据文件')</script>");
return ;
}
 导入参考
http://www.cnblogs.com/mc-dragon/archive/2008/03/24/624238.html