Professional Web Applications Themes

Country table and International Dialing Codes - Microsoft SQL / MS SQL Server

Hi, Anyone have a table of Countries, with their respective international dialing codes? Or, a link to such a table would be great. Thanks, Scott...

  1. #1

    Default Country table and International Dialing Codes

    Hi,

    Anyone have a table of Countries, with their respective international
    dialing codes?

    Or, a link to such a table would be great.

    Thanks,

    Scott


    Scott A. Keen Guest

  2. #2

    Default Re: Country table and International Dialing Codes

    Scott,

    You will find this in most telephone books.
    or [url]http://www.the-acr.com/codes/cntrycd.htm[/url] which doesn't appear to
    have any copyright restrictions.

    Regards
    AJ

    p.s. The above took a google search "international country codes telephone"
    so it's not the most difficult of things to find.

    "Scott A. Keen" <scottscottkeen.com> wrote in message news:erKl9KASDHA.1920TK2MSFTNGP11.phx.gbl...
    > Hi,
    >
    > Anyone have a table of Countries, with their respective international
    > dialing codes?
    >
    > Or, a link to such a table would be great.
    >
    > Thanks,
    >
    > Scott
    >
    >

    Andrew John Guest

  3. #3

    Default Re: Country table and International Dialing Codes

    Thanks....

    I was hoping to find something that was in a database format that I could
    import into SQL Server.

    Something comma delimited, or Access MDB, or DBF.



    "Dan Guzman" <danguzmannospam-earthlink.net> wrote in message
    news:%23YtO03ASDHA.632TK2MSFTNGP12.phx.gbl...
    > Check out [url]http://kropla.com/dialcode.htm[/url]
    >
    > --
    > Hope this helps.
    >
    > Dan Guzman
    > SQL Server MVP
    >
    > -----------------------
    > SQL FAQ links (courtesy Neil Pike):
    >
    > [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    > [url]http://www.sqlserverfaq.com[/url]
    > [url]http://www.mssqlserver.com/faq[/url]
    > -----------------------
    >
    > "Scott A. Keen" <scottscottkeen.com> wrote in message
    > news:erKl9KASDHA.1920TK2MSFTNGP11.phx.gbl...
    > > Hi,
    > >
    > > Anyone have a table of Countries, with their respective international
    > > dialing codes?
    > >
    > > Or, a link to such a table would be great.
    > >
    > > Thanks,
    > >
    > > Scott
    > >
    > >
    >
    >

    Scott Guest

  4. #4

    Default Re: Country table and International Dialing Codes

    Here you can try using this (copy and paste to a csv file):

    country Name; Country Code; ISO; Call Code
    Afghanistan;AF ; AFG ;93
    Albania;AL ; ALB ;355
    Algeria;DZ ; DZA ;213
    American Samoa;AS ; ASM ;1 684
    Andorra;AD ; AND ;376
    Angola;AO ; AGO ;244
    Anguilla;AI ; AIA ;1 264
    Antarctica;AQ ; ATA ;672
    Antigua and Barbuda;AG ; ATG ;1 268
    Argentina;AR ; ARG ;54
    Armenia;AM ; ARM ;374
    Aruba;AW ; ABW ;297
    Australia;AU ; AUS ;61
    Austria;AT ; AUT ;43
    Azerbaijan;AZ ; AZE ;994
    Bahamas;BS ; BHS ;1 242
    Bahrain;BH ; BHR ;973
    Bangladesh;BD ; BGD ;880
    Barbados;BB ; BRB ;1 246
    Belarus;BY ; BLR ;375
    Belgium;BE ; BEL ;32
    Belize;BZ ; BLZ ;501
    Benin;BJ ; BEN ;229
    Bermuda;BM ; BMU ;1 441
    Bhutan;BT ; BTN ;975
    Bolivia;BO ; BOL ;591
    Bosnia and Herzegovina;BA ; BIH ;387
    Botswana;BW ; BWA ;267
    Brazil;BR ; BRA ;55
    British Indian Ocean Territory;IO ; IOT ;
    British Virgin Islands;VG ; VGB ;1 284
    Brunei;BN ; BRN ;673
    Bulgaria;BG ; BGR ;359
    Burkina Faso;BF ; BFA ;226
    Burma (Myanmar);MM ; MMR ;95
    Burundi;BI ; BDI ;257
    Cambodia;KH ; KHM ;855
    Cameroon;CM ; CMR ;237
    Canada;CA ; CAN ;1
    Cape Verde;CV ; CPV ;238
    Cayman Islands;KY ; CYM ;1 345
    Central African Republic;CF ; CAF ;236
    Chad;TD ; TCD ;235
    Chile;CL ; CHL ;56
    China;CN ; CHN ;86
    Christmas Island;CX ; CXR ;61
    Cocos (Keeling) Islands;CC ; CCK ;61
    Colombia;CO ; COL ;57
    Comoros;KM ; COM ;269
    Cook Islands;CK ; COK ;682
    Costa Rica;CR ; CRC ;506
    Croatia;HR ; HRV ;385
    Cuba;CU ; CUB ;53
    Cyprus;CY ; CYP ;357
    Czech Republic;CZ ; CZE ;420
    Democratic Republic of the Congo;CD ; COD ;243
    Denmark;DK ; DNK ;45
    Djibouti;DJ ; DJI ;253
    Dominica;DM ; DMA ;1 767
    Dominican Republic;DO ; DOM ;1 809
    Ecuador;EC ; ECU ;593
    Egypt;EG ; EGY ;20
    El Salvador;SV ; SLV ;503
    Equatorial Guinea;GQ ; GNQ ;240
    Eritrea;ER ; ERI ;291
    Estonia;EE ; EST ;372
    Ethiopia;ET ; ETH ;251
    Falkland Islands;FK ; FLK ;500
    Faroe Islands;FO ; FRO ;298
    Fiji;FJ ; FJI ;679
    Finland;FI ; FIN ;358
    France;FR ; FRA ;33
    French Polynesia;PF ; PYF ;689
    Gabon;GA ; GAB ;241
    Gambia;GM ; GMB ;220
    Gaza Strip; ; ;970
    Georgia;GE ; GEO ;995
    Germany;DE ; DEU ;49
    Ghana;GH ; GHA ;233
    Gibraltar;GI ; GIB ;350
    Greece;GR ; GRC ;30
    Greenland;GL ; GRL ;299
    Grenada;GD ; GRD ;1 473
    Guam;GU ; GUM ;1 671
    Guatemala;GT ; GTM ;502
    Guinea;GN ; GIN ;224
    Guinea-Bissau;GW ; GNB ;245
    Guyana;GY ; GUY ;592
    Haiti;HT ; HTI ;509
    Holy See (Vatican City);VA ; VAT ;39
    Honduras;HN ; HND ;504
    Hong Kong;HK ; HKG ;852
    Hungary;HU ; HUN ;36
    Iceland;IS ; IS ;354
    India;IN ; IND ;91
    Indonesia;ID ; IDN ;62
    Iran;IR ; IRN ;98
    Iraq;IQ ; IRQ ;964
    Ireland;IE ; IRL ;353
    Isle of Man;IM ; IMN ;44
    Israel;IL ; ISR ;972
    Italy;IT ; ITA ;39
    Ivory Coast;CI ; CIV ;225
    Jamaica;JM ; JAM ;1 876
    Japan;JP ; JPN ;81
    Jersey;JE ; JEY ;
    Jordan;JO ; JOR ;962
    Kazakhstan;KZ ; KAZ ;7
    Kenya;KE ; KEN ;254
    Kiribati;KI ; KIR ;686
    Kosovo; ; ;381
    Kuwait;KW ; KWT ;965
    Kyrgyzstan;KG ; KGZ ;996
    Laos;LA ; LAO ;856
    Latvia;LV ; LVA ;371
    Lebanon;LB ; LBN ;961
    Lesotho;LS ; LSO ;266
    Liberia;LR ; LBR ;231
    Libya;LY ; LBY ;218
    Liechtenstein;LI ; LIE ;423
    Lithuania;LT ; LTU ;370
    Luxembourg;LU ; LUX ;352
    Macau;MO ; MAC ;853
    Macedonia;MK ; MKD ;389
    Madagascar;MG ; MDG ;261
    Malawi;MW ; MWI ;265
    Malaysia;MY ; MYS ;60
    Maldives;MV ; MDV ;960
    Mali;ML ; MLI ;223
    Malta;MT ; MLT ;356
    Marshall Islands;MH ; MHL ;692
    Mauritania;MR ; MRT ;222
    Mauritius;MU ; MUS ;230
    Mayotte;YT ; MYT ;262
    Mexico;MX ; MEX ;52
    Micronesia;FM ; FSM ;691
    Moldova;MD ; MDA ;373
    Monaco;MC ; MCO ;377
    Mongolia;MN ; MNG ;976
    Montenegro;ME ; MNE ;382
    Montserrat;MS ; MSR ;1 664
    Morocco;MA ; MAR ;212
    Mozambique;MZ ; MOZ ;258
    Namibia;NA ; NAM ;264
    Nauru;NR ; NRU ;674
    Nepal;NP ; NPL ;977
    Netherlands;NL ; NLD ;31
    Netherlands Antilles;AN ; ANT ;599
    New Caledonia;NC ; NCL ;687
    New Zealand;NZ ; NZL ;64
    Nicaragua;NI ; NIC ;505
    Niger;NE ; NER ;227
    Nigeria;NG ; NGA ;234
    Niue;NU ; NIU ;683
    Norfolk Island; ; NFK ;672
    North Korea;KP ; PRK ;850
    Northern Mariana Islands;MP ; MNP ;1 670
    Norway;NO ; NOR ;47
    Oman;OM ; OMN ;968
    Pakistan;PK ; PAK ;92
    Palau;PW ; PLW ;680
    Panama;PA ; PAN ;507
    Papua New Guinea;PG ; PNG ;675
    Paraguay;PY ; PRY ;595
    Peru;PE ; PER ;51
    Philippines;PH ; PHL ;63
    Pitcairn Islands;PN ; PCN ;870
    Poland;PL ; POL ;48
    Portugal;PT ; PRT ;351
    Puerto Rico;PR ; PRI ;1
    Qatar;QA ; QAT ;974
    Republic of the Congo;CG ; COG ;242
    Romania;RO ; ROU ;40
    Russia;RU ; RUS ;7
    Rwanda;RW ; RWA ;250
    Saint Barthelemy;BL ; BLM ;590
    Saint Helena;SH ; SHN ;290
    Saint Kitts and Nevis;KN ; KNA ;1 869
    Saint Lucia;LC ; LCA ;1 758
    Saint Martin;MF ; MAF ;1 599
    Saint Pierre and Miquelon;PM ; SPM ;508
    Saint Vincent and the Grenadines;VC ; VCT ;1 784
    Samoa;WS ; WSM ;685
    San Marino;SM ; SMR ;378
    Sao Tome and Principe;ST ; STP ;239
    Saudi Arabia;SA ; SAU ;966
    Senegal;SN ; SEN ;221
    Serbia;RS ; SRB ;381
    Seychelles;SC ; SYC ;248
    Sierra Leone;SL ; SLE ;232
    Singapore;SG ; SGP ;65
    Slovakia;SK ; SVK ;421
    Slovenia;SI ; SVN ;386
    Solomon Islands;SB ; SLB ;677
    Somalia;SO ; SOM ;252
    South Africa;ZA ; ZAF ;27
    South Korea;KR ; KOR ;82
    Spain;ES ; ESP ;34
    Sri Lanka;LK ; LKA ;94
    Sudan;SD ; SDN ;249
    Suriname;SR ; SUR ;597
    Svalbard;SJ ; SJM ;
    Swaziland;SZ ; SWZ ;268
    Sweden;SE ; SWE ;46
    Switzerland;CH ; CHE ;41
    Syria;SY ; SYR ;963
    Taiwan;TW ; TWN ;886
    Tajikistan;TJ ; TJK ;992
    Tanzania;TZ ; TZA ;255
    Thailand;TH ; THA ;66
    Timor-Leste;TL ; TLS ;670
    Togo;TG ; TGO ;228
    Tokelau;TK ; TKL ;690
    Tonga;TO ; TON ;676
    Trinidad and Tobago;TT ; TTO ;1 868
    Tunisia;TN ; TUN ;216
    Turkey;TR ; TUR ;90
    Turkmenistan;TM ; TKM ;993
    Turks and Caicos Islands;TC ; TCA ;1 649
    Tuvalu;TV ; TUV ;688
    Uganda;UG ; UGA ;256
    Ukraine;UA ; UKR ;380
    United Arab Emirates;AE ; ARE ;971
    United Kingdom;GB ; GBR ;44
    United States;US ; USA ;1
    Uruguay;UY ; URY ;598
    US Virgin Islands;VI ; VIR ;1 340
    Uzbekistan;UZ ; UZB ;998
    Vanuatu;VU ; VUT ;678
    Venezuela;VE ; VEN ;58
    Vietnam;VN ; VNM ;84
    Wallis and Futuna;WF ; WLF ;681
    West Bank; ; ;970
    Western Sahara;EH ; ESH ;
    Yemen;YE ; YEM ;967
    Zambia;ZM ; ZMB ;260
    Zimbabwe;ZW ; ZWE ;263
    Carlos Casalicchio is offline Junior Member
    Join Date
    May 2011
    Posts
    1

Similar Threads

  1. Module for Country/Country Codes Lists
    By Shlomi Fish in forum PERL Beginners
    Replies: 4
    Last Post: February 7th, 05:11 AM
  2. Dialing Out From Filemaker
    By Wellstone Jewelry in forum FileMaker
    Replies: 1
    Last Post: September 9th, 06:15 PM
  3. Powerbook dialing?
    By Scott in forum Mac Portable
    Replies: 1
    Last Post: August 18th, 07:14 PM
  4. Internet Explorer 6 not dialing up
    By Belinda in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 8th, 06:35 PM
  5. XP Pro problem when dialing through VPN
    By Nicholas Juttner in forum Windows Networking
    Replies: 0
    Last Post: July 1st, 01:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139