[AccessD] IATA Airport codes to import into MS Access database

It depends on how accurate you need to be

Here is one site that supplies IATA 3 char and IACO 4 char lists of
airport codes 30,000 total for 50$ in csv format.
Probably a more accurate breakdown
It may include military, emergency and dirt strips.
These are the backwoods ones you fly over at night, send a radio signal
on a pre-set frequency and the runway lights turn on..

http://www.mapping.com/airportcodes.html

IATA sell a subscription for $3000

This site states 9,400 large airports
http://www.world-airport-codes.com/

Some airports are a little odd. I have flown in here
BRR Barra in Outer Hebrides.
The runway is a sand beach, landings and take offs depend on the tide
There are scheduled flights in here

click on satellite map
http://www.world-airport-codes.com/united-kingdom/north-bay-630.html


William Hindman wrote:

>...why not post it on dba ...I've got an updated lat/long/post codes with US 
>and many international that I'll put up there soon as well ...its a rpita to 
>find high quality data lists that really provide what you need
>
>William Hindman
>
>----- Original Message ----- 
>From: <artful at rogers.com>
>To: "Access Developers discussion and problem solving" 
><accessd at databaseadvisors.com>
>Sent: Sunday, November 12, 2006 10:48 AM
>Subject: Re: [AccessD] IATA Airport codes to import into MS Access database
>
>
>  
>
>>I grabbed all the data from an airport list (which was subdivided by 
>>initial character) and I'm sending you off-list the MDB. If anyone else 
>>wants the list, pvt me and I will send it to you as well.
>>
>>Arthur
>>
>>----- Original Message ----
>>From: Shamil Salakhetdinov <shamil at users.mns.ru>
>>To: Access-D <accessd at databaseadvisors.com>
>>Sent: Sunday, November 12, 2006 8:48:07 AM
>>Subject: [AccessD] IATA Airport codes to import into MS Access database
>>
>>Hi All,
>>
>>Is there somewhere a file with IATA Airport codes ready to be imported 
>>into
>>MS Access database?
>>
>>I mean Airport codes like these:
>>http://en.wikipedia.org/wiki/List_of_airports_by_IATA_code:_L
>>
>>
>>Thank you.
>>
>>--
>>Shamil
>>
>>    
>>
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada