UK Address Database Wanted

[hullstorage]

Hi all,
Does anybody know where i can find a database with all the UK postcodes on it so i can use in Access.

So i enter a postcode and the information is then updated
i.e. street, town and county

Any ideas?

Thanks

 

[DCrake]

You can get them from the Post Office but there is a cost involved.

If you are trying to replicate that fast find service where you enter the house number and post code to retreive the full address, then this is a bolt on you can get from external sites but again there is a cost involved. If you consider there are 30m addresses in the UK you are going to have quite a large mdb.

David

 

[mcclunyboy]

is this anything related to this news article:

http://news.bbc.co.uk/1/hi/technology/7700621.stm

Most other available sources aren't as up-to-date your best bet is the post office if it is important...

 

[gemma-the-husky]

the data is copyright post office

PO will send you a sample - note that it is far from easy to use.

addresses are realy complex, in PO terms

 

[Uncle Gizmo]

the data is copyright post office

PO will send you a sample - note that it is far from easy to use.

addresses are realy complex, in PO terms

One of my customers has postcode lookup integrated into their database. There are several functions in the code behind the form which access the Address information via a postcode.dll file.

It works very well, the customer is very pleased with it, and although I did not set it up myself, from the look of it, it seems quite a simple task.

The postcode data is available from: ADF, some information about them on the software here:

http://www.componentsource.com/products/afd-postcode/index-gbp.html

 

[Uncle Gizmo]

There are some Open Source Postcode sources: "A Google"

More Open Source links:

http://www.npemap.org.uk/data/

http://www.freethepostcode.org/

http://random.dev.openstreetmap.org/postcodes/

 

[Uncle Gizmo]

There's a Net Library HERE: http://www.flipbit.co.uk/online-postcode-finder.html (Written in C)

Use a converter to convert it to VB.Net, and then adapt it to work in VBA...

 

[GaryPanic]

I have used this in Access and it was fine - problem though was the linceses cost