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 ? ..