Hi Everyone;
I have an access database and need to import different excel file by one click into a specific table in access. So the code will check if there is additional excel file added, will import it automatically and sift the the excel file into another folder. So that Microsoft access will not import duplicate excel file.
can any one help me with a code with a template in access.
the folder will be updated with different excel file but has same header in access table.
Tank you