Feb 19, 2015 03:32 PM|bbcompent1|LINK
alright, I think I may have figured out what is causing the duplication. If an excel file is the newer format of XLSX (2007/2010), OleDB will duplicate the records. If you run it through the older 2003 xls format, the duplication is not occurring according
to my testing. I am running really large files through the process just to see if that is the case or not. Stay tuned!