importing an excel file then normalising it

[philfer]

Hello,

I am using access to try to build a mangement reporting "application"

I have set up my tables for each manager etc etc

The sales, costs etc data comes in the form of an excel download from the accounting system. However it includes a lot of repeating data i.e. the manager name.

I am writing some code to copy the excel data and drop it into a table.

My question is what I do then to normalise the data

Is the best/only way to write a loop than goes through each field of the table and put in the managerid from the manager table into what will be the foreign key field in this newly normalised table.

Is there a better/easier way?

Am I overcomplicating things

Thanks
Phil

 

[namliam]

That depends on if you have Primary keys available in the excel file allready.

If you do... just running some (append) queries is all you need.