i have a code that seems to be excellent and professional (a code that prevent duplicates and check headers etc.) to import data from an excel file (code source there
) but i don't understand how exact the code is working. the function name is "ImportSpreadsheet" and the code is on a modle with the name "basImportXLS". i try to call this function on form "form1" with no success. i will be very thankful if someone will help me to use this function. i attached the access database and an excel file that it's came with this code.