C# Two Excel File inner join

Question

I would like to ask if it is possible to retrieve a row of data from a INNER JOIN query from TWO different Excel files (example. excel1.xls, excel2.xls). I am using C# .net. and an OledbConnection.

Excel1.xls Column 1 BookID 1234 1515 2315

Excel2.xls Column 1 BookID 1234 1515 1100 1412 2215

Goal: I must retrieve only those rows in Excel1.xls that are included in Excel2.xls

Here's my code for the function: txtshowstopperpath.text = path of the Excel1.xls txtexcelpath.text = Path of the Excel2.xls

    sConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={1};Extended Properties=Excel 12.0;";
    oConn = new OleDbConnection(sConnString);
oConn.Open();
sCommand = "SELECT * FROM [" + txtshowstopperpath.Text + "].[Sheet1$] A INNER JOIN [" + txtexcelpath.Text + "].[Sheet1$] B on A.[Book ID] = B.[Book ID]";       
oComm = new OleDbCommand(sCommand, oConn);
oRdr = oComm.ExecuteReader();
oTbl = new DataTable();
oTbl.Load(oRdr);
foreach (DataRow row in oTbl.Rows)
     {
         dgridshowrep.DataSource = oTbl;
    }
oConn.Close()

Thank you.

@RobAnthony - edited my post. sorry as this is my first time posting in this site. thank you — Mardith Pascua, Nov 25 '17 at 09:39
No, I don't believe you can. You will probably need to create two different data tables and the compare the data using some other method. — Mark Kram, Nov 25 '17 at 09:42
@MarkKram - thanks for your reply. Im stuck with this function. — Mardith Pascua, Nov 25 '17 at 09:44
I would look at using LINQ to extract the data that you want, this will get started: https://stackoverflow.com/questions/19449449/how-i-can-filter-a-datatable-with-linq-to-datatable — Mark Kram, Nov 25 '17 at 14:27
Here is a better link: https://stackoverflow.com/questions/665754/inner-join-of-datatables-in-c-sharp — Mark Kram, Nov 25 '17 at 15:27

C# Two Excel File inner join

0 Answers0