Hi Sherry

I used code below to import from excel

if (uploadFile.HasFile)
            {
                string strFile = MapPath("\\ExcelData\\" + uploadFile.FileName);

                uploadFile.SaveAs(strFile);

                string strConn = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0", strFile);
                OleDbConnection con = new OleDbConnection(strConn);
                OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", con);
                DataTable dt = new DataTable();
                da.Fill(dt);
              
                StringBuilder sb = new StringBuilder();
                sb.AppendFormat("<p>input file: {0}</p>", strFile);
                foreach (DataRow dr in dt.Rows)
                {
                    DocumentType dct = new DocumentType(1068);
                    umbraco.BusinessLogic.User u = new umbraco.BusinessLogic.User(0);
                    int parent = 1073;
                    Document d = Document.MakeNew(dr["name"].ToString(), dct, u, parent);
                    d.getProperty("price").Value = int.Parse(dr["price"].ToString());
                    d.getProperty("category").Value = 6;
                    d.getProperty("description").Value = dr["description"].ToString();

                    d.Publish(u);

                    umbraco.library.UpdateDocumentCache(d.Id);

                    sb.AppendFormat("{0}<br>", dr["name"]);
                }

                divTest.InnerHtml = sb.ToString();

            }

    }