用asp 把exce表格导入到数据库中。。
Dim ConnName,ConnStr Set ConnName = Server。CreateObject("ADODB。Connection") ' 建立Connection对象 ConnStr = "Data Source ="&FileName&";Extended Properties=Excel 8。 0" ConnName。Provider = "Microsoft。Jet。OLEDB。4。0 " ConnName。ConnectionString = ConnStr ConnName。Open。全部
Dim ConnName,ConnStr Set ConnName = Server。CreateObject("ADODB。Connection") ' 建立Connection对象 ConnStr = "Data Source ="&FileName&";Extended Properties=Excel 8。
0" ConnName。Provider = "Microsoft。Jet。OLEDB。4。0 " ConnName。ConnectionString = ConnStr ConnName。Open。收起