Seeking Advice for Importing from CSV without a unique id in source file
I am having to import several times a week from a csv file that changes daily but does not have a good unique id. I am faced with having records skipped due to errors and I think it is because sometimes the id in the source table may change slightly from import to import. Does anyone have any advice on how to create a unique ID in the source file (third party) that could help reduce errors? The ID field format is two or three letters followed by two spaces and then a series of numbers. It is very important that the records be updated most every day as things change constantly in the record. With the skipped record error, I also have no clue which records are being skipped. My database currently has 600+ records, but by the end of a two week period could have as many as 2 thousand.
Any help would be greatly appreciated.