Creating a Database From a Beast of an Excel Sheet

[Pullena]

Hello, I have an issue.



I work for a company that audits aircraft records and plans maintenance. I created a giant spreadsheet on Excel with 20+ worksheets, some with 4,000 lines, which allows me to plan and track maintenance. There are a lot of formulas, most are pretty basic, but often take information from over worksheets. For example, under components each line has some basic data that is copied in - part number, description etc, then the later columns calculate how much life is remaining on this part using the aircraft's total flight times, the total threshold of the maintenance and how close this part was to needing maintenance when it was first installed.

This week, my boss chucked a copy of Access 2010 on my desk and asked me whether it would be possible to put my spreadsheet into an Access database - I have never used Access before. The purpose of this is to make it more rigid so people can't break the spreadsheets.

How would I even go about starting this? I know that formulas can't be copied from Excel into Access, and it seems if you want to link the Excel and Access together, you then need to input all the data in Excel, which somewhat ruins the point. Hopefully just a prod in the right direction will help me begin this task. Any questions, let me know!

Pullena

[June7]

Maintenance tracking has been discussed in other threads. Maybe this will help https://www.accessforums.net/access/...sks-40106.html