We have a set of Data in MS Excel and we need to upload in MS Access database.
Build some queries and Forms so that the users can look in for the relevant details.
Importing excel documents into Access is the best approach.
I'll make class modules to handle data access as these can feed both forms and reports with more options than a classic query defintion could. I can use the classic query definitions as well if this is just one time quick prototyping.