Advertisement
JellyKuo

ODBC C# Excel

Apr 20th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.27 KB | None | 0 0
  1. string connStr = "Dsn=Excel Files;dbq=" + file + ";";
  2. OdbcConnection conn = new OdbcConnection(connStr);
  3. conn.Open();
  4. OdbcDataAdapter da = new OdbcDataAdapter("SELECT * FROM [工作表1$]", conn);
  5. DataTable dt = new DataTable();
  6. da.Fill(dt);
  7. dataGridView1.DataSource = dt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement