Maps


📖 Posts | 📎 Development, Microsoft, Windows | 🔖 maps, office, vba

Nearest Postcode Search in Microsoft Excel

I need to find a load of addresses by proximity to a postcode. I have the addresses in a Microsoft Access database. 1. Download Paul Jenkins’s UK Postcode csv and import into Access as a table 2. Create a query on your own table adding the following calculated field: <pre>PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], &#8221; &#8221; ) ) )</pre> Create a second query that joins the above query to the imported postcode table.