Help please

[dcarr]

I have a table that contains a lot of unnormalised data. The table contains two columns those being 'PKG_CODE' which is an alphanumeric two character code and 'PKG_DETAILS' that contains a list of publications that make up a package code i.e. LE+FT+FB+FD+FE'. I need to develop an application or module that is able to go into the table, extract the information from the table and is able to match the publication with the package code so it will look like

PKG_CODE PUB_CODE
========= ===========
1F LE
1F FT
1F FB

The amount of data held in this table is huge.

In addition to this from now on when changes are made to this table that contains the unnormalised data the program needs to be able to pick up any future changes and add be able to add the new changes/insertions to this new table? Any ideas

 

[dcx693]

Really not a good situation here. If you can't get the data in a better format, then you'll have to go in brute force with VBA code, read the data in the non-normalized table, and write the table in a normalized fashion to another table.

As for handling updates, you'll just have to run the code against the updated table each time and incorporate the updates into the normalized table using an update query.