extracting access tables using ado.net and comparing rows/columns for matches/nonmatches RRS feed

  • Question

  • how would I go about doing this?


    1. Extract Microsoft Access tables from 2 different databases to ;

       A.  compare rows by matchkey. Create log of all tables indicating

            1.   which rows match.

            2.   which rows don't match.

       B.  Column match.

            1. for all rows that do match, compare columns for each row.


    What is the best way to do this using ADO.NET?


    Thank you,



    Tuesday, April 1, 2008 6:45 PM