Hi all,

I have created a dB to track assets and the implementation of new assets.

The data is located in a flat .xls file which i have imported into my dB as a flat table. I want to move the data from that table into the respective relational tables and keep the relation.

Aaargh, how do I do this? I have tried an append query but I can only append one table at a time and then I can not retain the relations for all the data.

I am including a pic of the relations.

Please help.

Hope someone can help your cos I'm having the same problem and I'm tearing my hair for days trying to find a way around it. Good Luck.
:confused:

See this explaination of how to normalize a flat table.
http://www.access-programmers.co.uk/forums/showthread.php?t=80301

Thx for the help Pat, do you think you would be able to provide an example dB. If I sent you the dB that I am working on with the flat file. Could you use that to build the example?

Pat, please hold off on the dB example (If you where going to do it). I think I understand fully what you mean. I want to try on my own first.

Thx again