bull city bob
New Member
- Joined
- Feb 6, 2006
- Messages
- 14
My first Excel file is 17,000 lines. Columns a-h have patient data. Columns i-j have comments added when the data is reviewed (its a list of changes).
Second Excel file has 44,000 lines. Its cumulative from the first file.
I want to compare columns a-h of both files. If they are identical, I want to transfer the comments from columns i-j of the first file over to the second file.
I believe I should end up with a table of 44,000 lines and it will show the comments that were made on the original file (columns i-j). That way I can see which changes have already been reviewed.
I'm just getting to the intermediate lever in Access, and barely starting to know how to play around with SQL.
Second Excel file has 44,000 lines. Its cumulative from the first file.
I want to compare columns a-h of both files. If they are identical, I want to transfer the comments from columns i-j of the first file over to the second file.
I believe I should end up with a table of 44,000 lines and it will show the comments that were made on the original file (columns i-j). That way I can see which changes have already been reviewed.
I'm just getting to the intermediate lever in Access, and barely starting to know how to play around with SQL.