Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-13-2017, 01:00 AM   #1
Andrew Thorpe
Newly Registered User
 
Join Date: Apr 2009
Location: Cornwall, England
Posts: 51
Thanks: 3
Thanked 3 Times in 3 Posts
Andrew Thorpe is on a distinguished road
Postal Address from PostCode

Is there an add-on program for Access whereby you could type in a UK postcode and it would display the addresses belonging to that postcode?

Andrew Thorpe is offline   Reply With Quote
Old 08-13-2017, 01:36 AM   #2
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 1,631
Thanks: 29
Thanked 365 Times in 338 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: Postal Address from PostCode

I suspect that you'd either have to pay for this data or compile it yourself from various sources such as the Land Registry

However you may find the GetAddress site useful: https://getaddress.io/



You may also be interested in the fully searchable UK postcode database I uploaded yesterday:
https://www.access-programmers.co.uk...d.php?t=295233

This uses the freely available UK postcodes dataset from www.doogal.co.uk

NOTE:
If you get a free API key from the GetAddress site, you can download a full list of addresses for a particular postcode in JSON format
There is a limit of 20 API calls per day

In theory you could combine that with the list of postcodes I got from www.doogal.co.uk to get the dataset for the whole country BUT:
a) you'd have to pay for a licence allowing additional downloads - up to 5000 API calls per day
b) it would take forever to download
There are around 2.5 million UK postcodes (not all in use) so at 5000 per day it will take you 500 days .... AND the dataset will be mind boggingly huge

If you do find a freely available data source for what you want, please post the link here

UPDATE:
This site may also be useful https://www.hopewiser.com/address-postcode-finder
It offers a similar feature set to GetAddress - a limited number of free downloads then you have to pay.
Attached Images
File Type: jpg Capture.jpg (82.7 KB, 87 views)
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 08-13-2017 at 02:19 AM.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
Andrew Thorpe (08-13-2017)
Old 08-13-2017, 02:30 AM   #3
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 1,631
Thanks: 29
Thanked 365 Times in 338 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: Postal Address from PostCode

Further info for you.

The obvious place to look for this dataset is the Post Office and as you'd expect its not cheap....

http://www.postcodeaddressfile.co.uk...er_licence.htm

Single user licence = 399 for full record dataset ; 70 for partial record dataset (UK coverage)

HTH

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
Andrew Thorpe (08-13-2017)
Old 08-13-2017, 09:51 AM   #4
Andrew Thorpe
Newly Registered User
 
Join Date: Apr 2009
Location: Cornwall, England
Posts: 51
Thanks: 3
Thanked 3 Times in 3 Posts
Andrew Thorpe is on a distinguished road
Re: Postal Address from PostCode

Many thanks. I'll take a good look at those ideas. Andrew.

Andrew Thorpe is offline   Reply With Quote
Reply

Tags
postcode

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New postal address fields & mail merge s601superflow Forms 5 07-02-2014 07:21 PM
UK Postcode Address Database Table hullstorage General 8 02-23-2011 02:45 AM
find address depending on postcode and H.No aman Modules & VBA 8 05-12-2010 07:22 AM
Postal Code mugman17 ASP and ASP.NET 1 01-28-2008 12:56 AM
choosing postal address from home/business address everhopefull Reports 4 08-03-2005 01:01 PM




All times are GMT -8. The time now is 08:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World