I am trying to bring an "excel" database into a well-formed relational database format; it's a BOM, so I have SKUs and each of their components and nesting depths enumerated in this big table. I want to accomplish three things, I'm not quite sure how to go about them:
1. Copy all unique SKUs to a new table and AutoNumber
2. Copy all components and their related data to a new table and AutoNumber
3. Create a junction table that matches up the SKU ids with the Component ids based on the original table's relationships between them. This seems to be the trickiest.
1. and 2. I'm not sure if I can accomplish in one query or if it requires two each.
3. I'm, clueless