bill201
asked on
code to import data to access 2013 database from excel 2013 file
hi
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.
TestData.xlsx
ImportXLS.accdb
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.
TestData.xlsx
ImportXLS.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER