Taking a large Excel workbook and creating a database

[desertratz]

I have an extremely large amount of data 21 columns over 7000 rows attacthed is a sample of the data I need to track and create a database for. There are 113 pieces of equipment 4 different models, meaning different parts tracking only small variations. There are about 60 components per truck. I have tried to import but it will give me null values and such, so I figure I will create the tables and relationships. I also have one table that has all 113 equip numbers along with the date the hours were updated and the current hours for updating the equip hours. I will be tracking all the current components and when one is changed out I have to update the record and also have a history of it. TLDR; help I am stumped how do I split this into tables correctly. Thanks.TestData.txt

[June7]

That is really a very small amount of data.

Learn relational database principles and design. Here is a good tutorial site. http://www.rogersaccesslibrary.com/

Is this data for tracking maintenance? Maintenance db topic of numerous threads. Have you searched?

[desertratz]

That is really a very small amount of data.

Learn relational database principles and design. Here is a good tutorial site. http://www.rogersaccesslibrary.com/

Is this data for tracking maintenance? Maintenance db topic of numerous threads. Have you searched?

Small amount? That's one truck out of 112, I have searched but I will broaden the parameters I had seen a couple with good directions just nothing with that many items.

[June7]

Still not a large database. I have worked with posters having db of ~million records.

Bing: access database equipment maintenance
https://www.microsoftaccessexpert.co...-Database.aspx