Hello, I have a challenge I've been trying to resolve for a couple of days. I have one table with 27 columns. The data from that table is copied and pasted directly from Excel.
I also have one form based on that table. Once I paste the data from Excel into the table, I created an extra column of the memo data type. In the form it is a "comment" Field.
What I am struggling with is this. Every month I have new data to past from Excel into that column. I can easily add the new data to the table. But there will be times when I have duplicate rows - the duplicates will be based on three fields only. I don't want to paste over the table with the excel data because that would invalidate the "comment" field associated with each existing record before the paste. Cany anyone please recommend a solution or advice on code?
I should add that once I paste the data, if there are duplicates based on the three fields, I must delete only the ones that don't have a string in the "comment" field. Thank you!
I also have one form based on that table. Once I paste the data from Excel into the table, I created an extra column of the memo data type. In the form it is a "comment" Field.
What I am struggling with is this. Every month I have new data to past from Excel into that column. I can easily add the new data to the table. But there will be times when I have duplicate rows - the duplicates will be based on three fields only. I don't want to paste over the table with the excel data because that would invalidate the "comment" field associated with each existing record before the paste. Cany anyone please recommend a solution or advice on code?
I should add that once I paste the data, if there are duplicates based on the three fields, I must delete only the ones that don't have a string in the "comment" field. Thank you!
Last edited: