01.private System.Data.DataTable GetTable(string _SQL, string FileExcel)
02. {
03. string _ConnectionString = "Dsn=Excel Files;dbq=" + FileExcel + ";defaultdir=" + System.IO.Path.GetDirectoryName(FileExcel) + ";driverid=1046;maxbuffersize=2048;pagetimeout=5";
04. System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(_ConnectionString);
05. System.Data.DataSet ds = new System.Data.DataSet();
06.
07. conn.Open();
08. string strQuery = _SQL;
09. System.Data.Odbc.OdbcDataAdapter adapter = new System.Data.Odbc.OdbcDataAdapter(strQuery, conn);
10. adapter.Fill(ds);
11.
12.
13.
14.
15.
16. return ds.Tables[0];
17.
18. }
