How to compare all columns in two tables in MS access or excel ?
I have two tables with 50000 records with 100 columns. Both have same structure . Now i have to compare Original tables with Current tables and find out how many rows has different value and which column has ? So i can make the update query and update only those records.
Do we have any macro or any tool to compare two tables in excel or access ?
Microsoft AccessMicrosoft ExcelVisual Basic ClassicMicrosoft ApplicationsProgramming
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!