Excel matrix

[anna_717717]

’ve got several tables in Excel that I would like to convert to Access.

Variant Variant Type
Process1 Tool
Process1 Image
Process2 Tool
Process3 Tool

Table 1

Part Type Part number
A 1
A 2
A 3
B 1
B 2
B 3
C 1

Table 2


For Process1
Part A1 Part A2 Part A3
Part B1 Tool 1, Image 1 Tool 3, Image 3
Part B2 Tool 2, Image 2 Tool 2, Image 4
Part B3 Tool 1, Image 1 Tool1

Table 3

I’m using the tables to find the tools needed (and an image) etc. to
assemble a product. Their value might be dependant on one or more part types.
What tables/queries do I need to give me the information contained in table 3?

 

[Jeff Boyce]

Before you start, consider that Excel is a spreadsheet and Access is a
relational database. The way you've organized your data in Excel may not be
the best way in Access to give you good use of Access' tools.

If the terms "relational" and "normalized" are not familiar, spend some time
brushing up on these before attempting to migrate data from Excel to Access.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeanette Cunningham]

anna,
in addition to Jeff's valuable comments, this question has come up recently.
Do a search on excel matrix or similar to see how others have done this.


Jeanette Cunningham -- Melbourne Victoria Australia