To pick up data from formatted excel and add to access database

[LearnerAnu]

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.

 

[Nebu]

Hi:

Your data is not making much sense. The only thing I can suggest is to link this data to access and build in queries to pull the data in the structure you want in the access itself.

Thanks

 

[LearnerAnu]

Thanks..