Split GB Postcode ranges in to rows!!!!

[2013boris]

Does any one have any idea how to split GB postcode ranges into each rows.


Current data as like this
Postcode_from Postcode_until Townname Province
AB1 0AA AB1 0ZZ ABERDEEN ABERDEENSHIRE
AB1 1AA AB1 1ZZ ABERDEEN ABERDEENSHIRE
AB1 2AA AB1 2ZZ ABERDEEN ABERDEENSHIRE
AB1 3AA AB1 3ZZ ABERDEEN ABERDEENSHIRE

I need to make it like this
Postcode_from Townname Province
AB1 0AA ABERDEEN ABERDEENSHIRE
AB1 0AB ABERDEEN ABERDEENSHIRE
AB1 0AC ABERDEEN ABERDEENSHIRE
AB1 0AD ABERDEEN ABERDEENSHIRE

Other big issue is current GB data have more 50000 records if we split this into Rows i may need acces table.. how can i exported complet splited list into access table?
Does anyone know experience on this ? ..

[martindwilson]

it would probably be easier to download from here they are split like that
http://www.doogal.co.uk/PostcodeDownloads.php

[2013boris]

Thank you for the link.
i actually had to split data bcs each postcode range have defined to special area code if i could make the split postcode then i can also define this area code next to it . I hope i canable to do it

[martindwilson]

AB1 0AA ABERDEEN ABERDEENSHIRE
AB1 0AB ABERDEEN ABERDEENSHIRE
AB1 0AC ABERDEEN ABERDEENSHIRE
AB1 0AD how do you know that AB1 0AC for example exists it may not be used

[AlphaFrog]

What's the purpose to generate a line for every postcode? The reason I ask is if you want to create a postcode lookup table, there may be a clever way to use the original data to match postcodes in between the from and until post codes.