你好！

我现在想将一个Excel数据表里面的数据导入access里面，在导入数据之前，必须先添加 字段名称和数据类型。然后在将数据导入到对应的字段名称和数据类型下面。(代码完成)

请问您知道吗？如果你有了解的话，请指点 谢谢

access----文件-----获取外部数据----导入（选择excel）

public int   OutEexcl(string str )
        {
            int cout ;
                SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
        //设置execl文件的路径
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +str+ ";Extended Properties='Excel 8.0;IMEX=1'";

            OleDbConnection olconn = new OleDbConnection(strConn);
           //
            OleDbDataAdapter oada = new OleDbDataAdapter("select * from [sheet1$]", olconn);

            DataSet ds = new DataSet();
            try
            {//填充数据集
            
            oada.Fill(ds,"[Sheet1$]");
            olconn.Close();

        
            conn.Open();

            SqlCommand comm = new SqlCommand("InBooks",conn);

             = CommandType.StoredProcedure;
                //读取execl文件的所有行
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                     //这一行有数据，就填充到command对象的parameter参数中去
                    if(ds.Tables[0].Rows[0]["教材代码"].ToString() != " ")
                    {
                        comm.Parameters.Add("@bookid", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["教材代码"].ToString();

                        comm.Parameters.Add("@isdn", SqlDbType.NVarChar,255).Value = ds.Tables[0].Rows[i]["ISBN号"].ToString();

                        comm.Parameters.Add("@bookname", SqlDbType.NVarChar ,255 ).Value = ds.Tables[0].Rows[i]["教材名称"].ToString();

                        comm.Parameters.Add("@bookpusrh", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["版别"].ToString();

                        comm.Parameters.Add("@banci", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["版况"].ToString();

                        comm.Parameters.Add("@writer", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["作者"].ToString();

                        comm.Parameters.Add("@price", SqlDbType.Money ).Value = ds.Tables[0].Rows[i]["定价"];

                        comm.Parameters.Add("@purshyear", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["出版年月"].ToString();

                        comm.Parameters.Add("@bookclass", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["教材类别"].ToString();
                
                        comm.Parameters.Add("@jiangli ", SqlDbType.NVarChar ,255).Value = ds.Tables[0].Rows[i]["获奖等级"].ToString();

                        comm.Parameters.Add("@loct", SqlDbType.VarChar,255).Value = ds.Tables[0].Rows[i]["书架号"].ToString();

                        comm.Parameters.Add("@number", SqlDbType.Int).Value = ds.Tables[0].Rows[i]["库存"];

                        comm.Parameters.Add("@mayuan ", SqlDbType.Money ).Value = ds.Tables[0].Rows[i]["码洋"];

               
                //将execl文件导入数据库
                        comm.ExecuteNonQuery();
                    }
                }
                cout =1;
            }
            catch
            {
                cout =0;
            }


        
            conn.Close();
            return cout;
            
        }
这是我写将execl文件写到SQL SEVER 中的代码，你可以上面的路径改一下，把SQL SEVER的连接改为Acess 的连接.你可以到孟子E章来找