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

Hi William and Shamil

Here's an alternative:

http://crashpads.com/airport_codes/index.cfm

Don't fill in any field, just press the button to retrieve the full list - which can be saved as is to a text file.

/gustav

>>> wdhindman at dejpolsystems.com 12-11-06 17:28 >>>
...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