SQL Statement to populate a counties table
Insert Into tbl_Counties (County) Values ('Antrim')
Insert Into tbl_Counties (County) Values ('Armagh')
Insert Into tbl_Counties (County) Values ('Avon')
Insert Into tbl_Counties (County) Values ('Bedfordshire')
Insert Into tbl_Counties (County) Values ('Berkshire')
Insert Into tbl_Counties (County) Values ('Birmingham')
Insert Into tbl_Counties (County) Values ('Borders')
Insert Into tbl_Counties (County) Values ('Bristol')
Insert Into tbl_Counties (County) Values ('Buckinghamshire')
Insert Into tbl_Counties (County) Values ('Cambridgeshire')
Insert Into tbl_Counties (County) Values ('Carlow')
Insert Into tbl_Counties (County) Values ('Cavan')
Insert Into tbl_Counties (County) Values ('Central')
Insert Into tbl_Counties (County) Values ('Channel Islands')
Insert Into tbl_Counties (County) Values ('Cheshire')
Insert Into tbl_Counties (County) Values ('Clare')
Insert Into tbl_Counties (County) Values ('Clwyd')
Insert Into tbl_Counties (County) Values ('Cork')
Insert Into tbl_Counties (County) Values ('Cornwall')
Insert Into tbl_Counties (County) Values ('County Durham')
Insert Into tbl_Counties (County) Values ('Cumbria')
Insert Into tbl_Counties (County) Values ('Derbyshire')
Insert Into tbl_Counties (County) Values ('Devon')
Insert Into tbl_Counties (County) Values ('Donegal')
Insert Into tbl_Counties (County) Values ('Dorset')
Insert Into tbl_Counties (County) Values ('Down')
Insert Into tbl_Counties (County) Values ('Dublin')
Insert Into tbl_Counties (County) Values ('Dumfries and Galloway')
Insert Into tbl_Counties (County) Values ('Dyfed')
Insert Into tbl_Counties (County) Values ('East Yorkshire')
Insert Into tbl_Counties (County) Values ('Edinburgh')
Insert Into tbl_Counties (County) Values ('Essex')
Insert Into tbl_Counties (County) Values ('Fermanagh')
Insert Into tbl_Counties (County) Values ('Fife')
Insert Into tbl_Counties (County) Values ('Galway')
Insert Into tbl_Counties (County) Values ('Glasgow')
Insert Into tbl_Counties (County) Values ('Gloucestershire')
Insert Into tbl_Counties (County) Values ('Grampian')
Insert Into tbl_Counties (County) Values ('Greater Manchester')
Insert Into tbl_Counties (County) Values ('Gwent')
Insert Into tbl_Counties (County) Values ('Gwynedd')
Insert Into tbl_Counties (County) Values ('Hampshire')
Insert Into tbl_Counties (County) Values ('Herefordshire')
Insert Into tbl_Counties (County) Values ('Hertfordshire')
Insert Into tbl_Counties (County) Values ('Highland')
Insert Into tbl_Counties (County) Values ('Isle of Man')
Insert Into tbl_Counties (County) Values ('Isle of Wight')
Insert Into tbl_Counties (County) Values ('Kent')
Insert Into tbl_Counties (County) Values ('Kerry')
Insert Into tbl_Counties (County) Values ('Kildare')
Insert Into tbl_Counties (County) Values ('Kilkenny')
Insert Into tbl_Counties (County) Values ('Lancashire')
Insert Into tbl_Counties (County) Values ('Laois')
Insert Into tbl_Counties (County) Values ('Leicestershire')
Insert Into tbl_Counties (County) Values ('Leitrim')
Insert Into tbl_Counties (County) Values ('Limerick')
Insert Into tbl_Counties (County) Values ('Lincolnshire')
Insert Into tbl_Counties (County) Values ('London')
Insert Into tbl_Counties (County) Values ('Londonderry')
Insert Into tbl_Counties (County) Values ('Longford')
Insert Into tbl_Counties (County) Values ('Lothian')
Insert Into tbl_Counties (County) Values ('Louth')
Insert Into tbl_Counties (County) Values ('Mayo')
Insert Into tbl_Counties (County) Values ('Meath')
Insert Into tbl_Counties (County) Values ('Merseyside')
Insert Into tbl_Counties (County) Values ('Middlesex')
Insert Into tbl_Counties (County) Values ('Mid Glamorgan')
Insert Into tbl_Counties (County) Values ('Monaghan')
Insert Into tbl_Counties (County) Values ('Norfolk')
Insert Into tbl_Counties (County) Values ('North Yorkshire')
Insert Into tbl_Counties (County) Values ('Northamptonshire')
Insert Into tbl_Counties (County) Values ('Northumberland')
Insert Into tbl_Counties (County) Values ('Nottinghamshire')
Insert Into tbl_Counties (County) Values ('Offaly')
Insert Into tbl_Counties (County) Values ('Orkney')
Insert Into tbl_Counties (County) Values ('Oxfordshire')
Insert Into tbl_Counties (County) Values ('Powys')
Insert Into tbl_Counties (County) Values ('Roscommon')
Insert Into tbl_Counties (County) Values ('Shetland')
Insert Into tbl_Counties (County) Values ('Shropshire')
Insert Into tbl_Counties (County) Values ('Sligo')
Insert Into tbl_Counties (County) Values ('Somerset')
Insert Into tbl_Counties (County) Values ('South Glamorgan')
Insert Into tbl_Counties (County) Values ('South Yorkshire')
Insert Into tbl_Counties (County) Values ('Staffordshire')
Insert Into tbl_Counties (County) Values ('Strathclyde')
Insert Into tbl_Counties (County) Values ('Suffolk')
Insert Into tbl_Counties (County) Values ('Surrey')
Insert Into tbl_Counties (County) Values ('Sussex')
Insert Into tbl_Counties (County) Values ('Tayside')
Insert Into tbl_Counties (County) Values ('Tipperary')
Insert Into tbl_Counties (County) Values ('Tyne and Wear')
Insert Into tbl_Counties (County) Values ('Tyrone')
Insert Into tbl_Counties (County) Values ('Warwickshire')
Insert Into tbl_Counties (County) Values ('Waterford')
Insert Into tbl_Counties (County) Values ('West Midlands')
Insert Into tbl_Counties (County) Values ('West Yorkshire')
Insert Into tbl_Counties (County) Values ('Western Isles')
Insert Into tbl_Counties (County) Values ('West Glamorgan')
Insert Into tbl_Counties (County) Values ('Westmeath')
Insert Into tbl_Counties (County) Values ('Wexford')
Insert Into tbl_Counties (County) Values ('Wicklow')
Insert Into tbl_Counties (County) Values ('Wiltshire')
Insert Into tbl_Counties (County) Values ('Worcestershire')