Hi
i imported an excel file with the following strcture:
Field A: Accronym
Field B: Label1
Field C: Label2
Field D: Label3
(plus an primary key when i imported)

Sometimes Field C and D are empty.

What I am looking in doing is to get a good desgin is three tables
one with the accronyms, another one with the labels (without double in the unlikely event there were double labels) and the third table joining the two tables. Accronyms are unique.

I am just unsure how i can do other thsn typing it all ?
I tried to table analysis tool... but i can't do what i want to.
Do you have any idea ?

Hi,

A common technique when importing data that requires processing for normalization is to import the data into a temp table and then run a series of action queries against the data, splicing it into the required final tables.

Perhaps that will give some direction where you may focus. For example, "INSERT INTO NormalizedTable (ThisFIeld, ThatField) SELECT ThisField, ThatField FROM TempImportTable WHERE SomeConditionIsTrue"

Selecting out of the temp and appending into the normalized tables usually gets us where we need to be.

hth

Hi

From what I can tell of your example I think you'd only need two tables ?

It seems that you'd have a one to many relationship, as in one acronym could have many labels, meaning two tables or could one acronym have many labels and one label have many acronyms, in which case it would be a many to many relationship and then you'd need the third junction table.

Either way though, it would be INSERT action queries that would do the job for you without having to resort to manually typing things (IMG:style_emoticons/default/wink.gif)