C# how to read two excel sheets using join
Posted on 2013-06-21
I have figured out how to read in a spreadsheet in c# using odbcDataReader. See below:
string SQL = "Select * from [TransactionHeader$]";
"select * from [TransactionMaster$]";
using (OdbcCommand com = new OdbcCommand(SQL, con1, null))
using (OdbcDataReader reader = com.ExecuteReader())
int Fields = reader.FieldCount;
string value = reader + " " + reader + " ";
MessageBox.Show(value.ToString() + Fields);
Now I would like to be able to do a similiar type of read, but joining two Sheets (TransascionMaster & TransactionHeader). The SQL statement would be something like this:
select * from [TransactionMaster$], [TransactionHeader$] where TransactionMaster.CELL1 = TransactionHeader.CELL5"
Can I do this and if so what is the format of the SQL statement?