怎么将excel里的数据导入到SQL数据库阿？？
我知道先把excel的数据填充到dataset里,然后再添加到数据库
我做了一个总是有错,我把代码传上来了,高手指点一下是那里的错误

我再网上找了半天了 代码我看没什么问题 可还是不知道哪里错了

大哥能不能把代码写一下啊???

string strPath = File1.PostedFile.FileName;

System.Data.OleDb.OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+strPath+";Extended Properties=""Excel 8.0;""");
conn.Open();
System.Data.OleDb.OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM [1$]";
System.Data.OleDb.OleDbDataReader rdr = cmd.ExecuteReader();
DataSet dataSet11 = new DataSet();
这样写对不对？
cmd.CommandText = "SELECT * FROM [1$]";
中的[1$]代表的是不是Excel的名字啊？？

什么是工作薄，比如说是什么。
我不太懂啊

帮我看看这段代码对吗??

string strPath,FileName;
strPath=File1.PostedFile.FileName;
FileName=strPath.Substring(strPath.LastIndexOf("\\")+1);
if(strPath == "")
{
Response.Write("<script>alert('请先选择文件')</script>");
return;
}
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strPath + ";" +
"Extended Properties=Excel 8.0;";

OleDbConnection objConn = new OleDbConnection(sConnectionString);
try
{

objConn.Open();
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [常规产品清册$]", objConn); //这里的sheet用不用带[]和里面的$阿？？
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

objAdapter1.SelectCommand = objCmdSelect;
DataSet dsolb = new DataSet();
objAdapter1.Fill(dsolb,"常规产品清册"); //这里是写sheet吗？？
DataGrid1.DataSource = dsolb.Tables[0].DefaultView;
DataGrid1.DataBind();
}
catch(Exception ee)
{
Response.Write("<script>alert('请先关闭文件')</script>");
return;
}
finally
{
objConn.Close();
}

[此贴子已经被作者于2006-9-6 15:55:32编辑过]

你说的是左下角的页选项上的名字吧？

还是不行 你帮我看看我发的代码那里有问题啊？？？？

高手大大我下班了，记得帮我看看代码。
我明天再来看
谢谢了

问题解决了 谢谢大家 我把正确代码发上来了 不会的可以看看。。

string strPath = File1.PostedFile.FileName;
if(strPath == "")
{
Response.Write("<script>alert('请先选择文件')</script>");
return;
}
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strPath + ";" +
"Extended Properties=Excel 8.0;";

// Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(sConnectionString);
try
{

// Open connection with the database.
objConn.Open();

// The code to follow uses a SQL SELECT command to display the data from the worksheet.

// Create new OleDbCommand to return data from worksheet.
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM[常规产品清册$]", objConn);
/*************************************************************
**********************测试读取单列****************************
OleDbDataReader dr = objCmdSelect.ExecuteReader();
while(dr.Read())
{
Response.Write("产品类别"+dr[2].ToString());
}
dr.Close();
***************************************************************/
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;

// Create new DataSet to hold information from the worksheet.
DataSet dsolb = new DataSet();

// Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(dsolb);

// Bind data to DataGrid control.
DataGrid1.DataSource = dsolb;
DataGrid1.DataBind();
}
catch(Exception ee)
{
Response.Write("<script>alert('请先关闭文件')</script>");
return;
}
finally
{
// Clean up objects.
objConn.Close();
}