Does anybody know of a plug-in or program that can import two csv files,merge them, and delete duplicate data?

Question

Does anybody know of a plug-in or program that can import two csv files,merge them, and delete duplicate data?

Answer 1

DISTINCT and JOIN statements in SQL.  You can easy write a macro for it in any language.

Answer 2

Microsoft Excel

Answer 3

Do you know with a certainty that these two CSV files have the same information in the same order?  As a test, you could open a blank Excel file and "open" the CSV file.  You will have to indicate that it is delimited and name the character that delimits them (comma, tab, etc).

Then, open another Excel file and repeat with the other CSV file.  

Now, with the cursor on 1 preceding Row 1, right-click and Insert.  You will insert a blank row where you can type headings.  Repeat for the other file.  How do they compare?  If not exactly the same in order and content, you will have to rearrange columns in one file to match the other.

When you have accomplished this, you can simply select and copy all the data in one file and paste it at the end of the other.  (I suggest copy instead of cut just in case.  You can always delete later.)

As for importing two CSV files and merging them into one, the only place I have seen this so far is in Outlook, where you can import addresses and omit duplicates.  If you find out otherwise I would appreciate a message.