pcsoft.us.windevCopyright 2026, PC SOFT27 Dec 2019 16:12:53 Z23 Dec 2019 18:03:03 Zhello folks please consider this very small piece of code [code:wl] HImportXLS(Shoes_Tag, My_Excel_File, 1, "", hImpTestDuplicates+hImpIgnoreFirstLine) IF ErrorOccurred THEN Error(HErrorInfo()) END [/code] and the structure os the related table (I don't know if can be useful, anyway here it is) https://hostimage.windev.io/images/Structure_1d33390436a821ad2b6f1efeb7b570c1.jpg my problem is: every time the code above is launched, Windev add ALL the rows of the Excel sheet without any regard to the Unique Key (DataNumero, the last row in the picture) defined inthe table structure. 1) the file Excel and the .FIC table has the same structure 2) at every run I don't receive any error message and the table is re-re-re-re-filled with ALL the Excel rows 3) I think that, when importing data, Windev has to do ALL the "dirty work", automatic fillng the keys and checking the index Where am I doing wrong?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67514-import-data-from-excel/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)olivier.harraupcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67514-import-data-from-excel-67517/read.awp27 Dec 2019 16:12:53 ZHi VEGEboss, "hImpTestDuplicates" will only avoid to have duplicates if you use it with "hCopyAutoId" (hCopyAutoId+hImpTestDu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67514-import-data-from-excel-67517/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67514-import-data-from-excel-67517/read.awpimport data from Excel