Cust table with country and state data

13/06/2008, 01h56

While it is easy to make a customer table, I am looking for a setup that
references country and state information with prefilled state names.

So, I am looking for a country table with all country names (and preferably
their phone prefix) so
US, 1,
France, 33,
Australia, 61,
NZ, 64
, etc
the default domain extension would be great.
I know there is a standard defining the countries and their short form, so
meeting this standard would be great.

I am then looking for a state table with data, so
Aus, Qld, Queensland
Aus, NSW, New South Wales
Aus, Vic, Victoria
....
USA, Alaska, AL
USA, New York, NY

The hard part is obtaining the data. Google has not been my friend.

Can anyont point me to a source for this?

Thanks
Andrew.

13/06/2008, 03h55

Maybe start with Wikipedia...
http://en.wikipedia.org/wiki/Lists_of_countries

13/06/2008, 01h56	#1
Andrew Baker Messages: n/a Hébergeur:	Cust table with country and state data While it is easy to make a customer table, I am looking for a setup that references country and state information with prefilled state names. So, I am looking for a country table with all country names (and preferably their phone prefix) so US, 1, France, 33, Australia, 61, NZ, 64 , etc the default domain extension would be great. I know there is a standard defining the countries and their short form, so meeting this standard would be great. I am then looking for a state table with data, so Aus, Qld, Queensland Aus, NSW, New South Wales Aus, Vic, Victoria .... USA, Alaska, AL USA, New York, NY The hard part is obtaining the data. Google has not been my friend. Can anyont point me to a source for this? Thanks Andrew.

13/06/2008, 03h55	#2
Eric Isaacs Messages: n/a Hébergeur:	Re: Cust table with country and state data Maybe start with Wikipedia... http://en.wikipedia.org/wiki/Lists_of_countries

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email