Created a link between two tables from Excel to Access 2010 Professional
I have two tables created in Excel. One table has 38 fields with student id number as one of the fileds. I have another table with the same student id number (labeled OtherID and UICnumber). I want to compare the two tables where the student id number matches the other id in one table and add the UICnumber into the table with the 38 fields when the student id number matches the otherid.