Hi,
I am new to coding and VBA. I have been assigned a part of the application we are designing for a client. I have been going through tutorials but am not able to pick the data from excel sheet which is present in a particular format and add to access database table with field names that are not same to excel. Though i have been successful in connecting the applications, but i am not able to create a proper loop.
I am attaching the format sheet . Kindly help me to add this excel data to access database. I have also put in the structure of my database in the file.
Kindly help.