怎么用ASP对excel文件进行查询、添加、修改、删除？

conn.open "driver={microsoft access driver (*.mdb)}dbq="&server.mappath("xhnew.mdb")

修改为：

conn.open "DBQ=d:\newexcel.xlsDefaultDir=DRIVER={Microsoft Excel Driver (*.xls)}"

DataSet _Table = GetTableName(Server.MapPath(@"upload/" + Request.Cookies["sa"].Value + "/" + this.ListBox1.SelectedValue), this.DropDownList1.SelectedValue)//首先获取EXCEL文件路径

string[] list = Request["checkbox"].Split(",".ToCharArray())要导入的列，代码不贴了

string CompanyName = string.Empty, Person_in_charge = string.Empty, Mobile = string.Empty, Phone = string.Empty, Fax = string.Empty, E_mail = string.Empty, Address = string.Empty, IMQQ = string.Empty, AliWW = string.Empty, Website = string.Empty

if (_Table.Tables[0].Rows.Count >0)

{

for (int i = 0i != _Table.Tables[0].Rows.Counti++)/

{

for (int j = 0j <list.Lengthj++)/判断每个列的数据，然后处理

{

string[] arr = list[j].ToString().Split("|".ToCharArray())

if (Request[list[j].ToString()] == "CompanyName")

{

CompanyName = CompanyName + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "Person_in_charge")

{

Person_in_charge = Person_in_charge + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "Mobile")

{

Mobile = Mobile + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "Phone")

{

Phone = Phone + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "Fax")

{

Fax = Fax + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "E-mail")

{

E_mail = E_mail + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "Address")

{

Address = Address + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "IMQQ")

{

IMQQ = IMQQ + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "AliWW")

{

AliWW = AliWW + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

if (Request[list[j].ToString()] == "Website")

{

Website = Website + _Table.Tables[0].Rows[i][arr[1].ToString()].ToString()

}

}

db.Update_Sql("INSERT INTO Customers([sid],[s_dep],[CompanyName],[Person_in_charge],[Mobile],[Phone],[Fax],[E-mail],[Address],[IMQQ],[AliWW],[Website],[Industry])VALUES('" + Request.Cookies["sa"].Value + "'," + Request.Cookies["dep"].Value + ",'" + CompanyName + "','" + Person_in_charge + "','" + Mobile + "','" + Phone + "','" + Fax + "','" + E_mail + "','" + Address + "','" + IMQQ + "','" + AliWW + "','" + Website + "'," + this.DropDownList2.SelectedValue + ")")

CompanyName = ""Person_in_charge = ""Mobile = ""Phone = ""Fax = ""E_mail = ""Address = ""IMQQ = ""AliWW = ""

this.Label3.Text = "导入成功！"

1.

把本地的Excel文件上传到服务器的指定目录下

2.

写一段代码，用ASP连接EXCEL表（和连SQL

Server数据库差不多），读出数据

3.

把读出来的数据一条一条插入到SQL

Sever的表中

步骤差不多这样，至于ASP如何连接EXCEL表等问题，你可以去上学吧网站找几本ASP方面的电子书，下载下来看看

---