示例:
public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
conn.Close();
return schemaTable;
}
读取EXCEL
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strFileName + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection conn=new OleDbConnection(strConn);
conn.Open();
DataTable schemaTable=conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
string tableName=schemaTable.Rows[0][2].ToString().Trim();
string strSql="select * from["+tableName+"]";
OleDbCommand cmd=new OleDbCommand(strSql,conn);
OleDbDataAdapter ExcelDA=new OleDbDataAdapter();