Denormalize.mdb (intermediate)

Please consider donating $1 per sample downloaded, find out why here
Download
Denormalize.zip
Access 97 (32 KB)

Assume the tables below:

Denormalize takes the data in table1 and creates table2. Thus it denormalizes a normalized table. This has 4 subs/functions. "DenormalizeTable" is the main sub which calls the others. "CreateDenormalizedTable" deletes and re-creates table2. It calls "MaxNumberOfFields" to decide how many fields to create. Lastly, "DenormalizeIt" does the denormalization.

To execute it, go the module, put your cursor in the first sub, and push the execute button.

TABLE1
ID   Value
1    10
1    20
2    30
2    40
2    50
2    60
2    70
3    80
3    90
4    100

TABLE2
ID  Value1  Value2  Value3  Value4  Value5
1   10
2   30      40      50      60      70
3   80      90
4   100

 

Feedback

 

Need Winzip?

Return to Main Page