Hi there.
This appears to be getting a little off-track. Let me see what I can add to help with an understanding of the situation.
Let's start with the easiest part. I don't believe there is anything around that will convert even a single Excel project into an Access one of any complexity whatever. Feel free to search but do be very wary of any claims.
Clearly, for such work you'd need expertise in both Excel & Access. I would suggest that the
Access Answers forum be a better place to post such a question but I can see why that may not have been obvious when you posted it.
So on to your question. It is at the extreme edge - if not beyond - what is allowed as a question here on Bytes.com. Questions are to be specific and on a single technical subject. Yours is very open-ended in that there are so many possible variables that affect the answer that it's almost impossible to give you anything remotely helpful. That, by the way, is why we at Bytes.com have made it so clear that these types of question are not allowed. They waste everybody's time as no-one knows what the question's really about - and you as the poster get very ittle from them.
Luckily for you, CactusData has already given a very considered response to the question you actually asked. It's actually about how to approach a project rather than any technical details from either Excel or Access. Nevertheless their answer was helpful as far as it went.
It seems that, rather than exactly what you asked for though, you are looking for help in building the project itself. That is not something we do here as explained if you read the Bytes.com rules. What I think that you perhaps don't understand is the scope of your project. It's not something Bytes.com would typically get involved with as explained earlier but perhaps if you considered yourself as standing outside a building asking for help getting your case inside and up the stairs. What you don't seem to appreciate is the building is actually the Burj Khalifa.
My advice, based on very little detail even of any of the Excel data, would be that it's unlikely to be within your current capabilities. It's certainly not trivial (unless your starting data is extremely so, but then in that case I would have expected you to have said so before this point) and will very like require that you get expert help.
9
