1) Create a procedure to extract records from a 3.5 meg text file (mht) of airports and create a Microsoft Access table with this data.
2) Create an Access query to add a field inserting the closest airport to each zipcode in a zipcode table. Both tables have latitude and longitude data.
All Access tables, procedures and queries be Access 2000 compatible.
I will need to see the calculation you will be using for determining the closest airport to the zipcode before we proceed. Thank you. I have attached the airport file you will be working with.
