import unnormalized .txt coloms to row

[Geert]

Hello,

I import a unnormalized .txt file. I want to change the colomn in table 1(only year) in rows. My database will have then the right structure.

i can not change the import file. I need to change the structure.

tabel 1:
Activa-id 2005 2006 2007 2008 2009 2010
1 850 935 1029 1132 1245 1370
2 1000 1060 1124 1191 1262 1338
3 1150 1219 1292 1370 1452 1539
4 1300 1378 1461 1549 1642 1741
5 1450 1537 1629 1727 1831 1941


Tabel 2 have to be: I want this:
Activa-id Jaren Afschrijvingsbedrag
1 2005 850
1 2006 935
1 2007 1029
1 2008 1132
1 2009 1245
1 2010 1370
2 2005 1000
2 2006 1060
2 2007 1124
2 2008 1191
2 2009 1262
2 2010 1338

I hope that you understand me. Excuse me for the language failers. I am a common Dutch guy. I hope dat somebody can help me. I learned here already very much on this forum. I appreciate this very much.

Regards Gerard

 

[Pat Hartman]

You need to run an append query for each year column. The query will select the key, the year will be supplied by you as a literal value, and the data from one specific column will be selected. Your example shows 6 years so it will take 6 append queries to normalize.

 

[Geert]

Hi Pat,

Thanks for your answer. My problem is solved.

Thank you very much,

Regards

Geert

(I am very happy with this forum)