I am very frustrated trying to compare data here. I am trying to compare data from an SQL server table to a flat file. Since not one table contains the data that this flat file contains I did the following.
Created an import template that pulls in an SQL query matching the flat file format, and imports this into an Access Database.
Created another import template that pulls in the flat file and imports this into the same access Database.
Keep in mind both of these tables are identical in structure. Same column names, same number of columns, same primary key and foreign key.
However, when I try to do the compare, after I select the originating table and target object, the select columns dialog that comes up is completely blank. No columns are displayed. If you cancel out of this dialog, there will be a red x showing on this table I am comparing saying No keys to compare.
What is going on? Why can I not compare these two ‘identical schema’ tables???