从EXCEL表中查出数据

最新推荐文章于 2024-10-31 01:51:08 发布

cecil323

最新推荐文章于 2024-10-31 01:51:08 发布

阅读量382

点赞数

分类专栏：业务清单管理系统文章标签： excel properties 数据库 cmd

业务清单管理系统专栏收录该内容

9 篇文章 0 订阅

订阅专栏

fu_path.SaveAs(Server.MapPath("~/table/" + tablename));//上传文件保存路径

            //上传表数据库连接设置
            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = "Provider = Microsoft.Jet.OleDb.4.0;" + "Extended Properties=Excel 8.0;";
            conn.ConnectionString += "Data source = " + Server.MapPath(@"table/" + tablename);

conn.Open();

OleDbDataReader reader;

OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;

cmd.CommandType = CommandType.Text;

            //从上传表查出数据
            cmd.CommandText = "SELECT * FROM [Sheet1$]";
            reader = cmd.ExecuteReader();