How to Insert all countries names with their values into DB

Question

I want import all countries names with their values From internet into Database

Dharmraj Thakur · Answer

I Think you are looking for... CREATE TABLE dbo.Countries ( ID int primary key identity(11) Name varchar (50) ); INSERT INTO Countries ( Name ) VALUES ( 'Afghanistan' ); INSERT INTO Countries ( Name ) VALUES ( 'Albania' ); INSERT INTO Countries ( Name ) VALUES ( 'Algeria' ); INSERT INTO Countries ( Name ) VALUES ( 'Andorra' ); INSERT INTO Countries ( Name ) VALUES ( 'Angola' ); INSERT INTO Countries ( Name ) VALUES ( 'Anguilla' ); INSERT INTO Countries ( Name ) VALUES ( 'Antigua & Barbuda' ); INSERT INTO Countries ( Name ) VALUES ( 'Argentina' ); INSERT INTO Countries ( Name ) VALUES ( 'Armenia' ); INSERT INTO Countries ( Name ) VALUES ( 'Australia' ); INSERT INTO Countries ( Name ) VALUES ( 'Austria' ); INSERT INTO Countries ( Name ) VALUES ( 'Azerbaijan' ); INSERT INTO Countries ( Name ) VALUES ( 'Bahamas' ); INSERT INTO Countries ( Name ) VALUES ( 'Bahrain' ); INSERT INTO Countries ( Name ) VALUES ( 'Bangladesh' ); INSERT INTO Countries ( Name ) VALUES ( 'Barbados' ); INSERT INTO Countries ( Name ) VALUES ( 'Belarus' ); INSERT INTO Countries ( Name ) VALUES ( 'Belgium' ); INSERT INTO Countries ( Name ) VALUES ( 'Belize' ); INSERT INTO Countries ( Name ) VALUES ( 'Benin' ); INSERT INTO Countries ( Name ) VALUES ( 'Bermuda' ); INSERT INTO Countries ( Name ) VALUES ( 'Bhutan' ); INSERT INTO Countries ( Name ) VALUES ( 'Bolivia' ); INSERT INTO Countries ( Name ) VALUES ( 'Bosnia & Herzegovina' ); INSERT INTO Countries ( Name ) VALUES ( 'Botswana' ); INSERT INTO Countries ( Name ) VALUES ( 'Brazil' ); INSERT INTO Countries ( Name ) VALUES ( 'Brunei Darussalam' ); INSERT INTO Countries ( Name ) VALUES ( 'Bulgaria' ); INSERT INTO Countries ( Name ) VALUES ( 'Burkina Faso' ); INSERT INTO Countries ( Name ) VALUES ( 'Myanmar/Burma' ); INSERT INTO Countries ( Name ) VALUES ( 'Burundi' ); INSERT INTO Countries ( Name ) VALUES ( 'Cambodia' ); INSERT INTO Countries ( Name ) VALUES ( 'Cameroon' ); INSERT INTO Countries ( Name ) VALUES ( 'Canada' ); INSERT INTO Countries ( Name ) VALUES ( 'Cape Verde' ); INSERT INTO Countries ( Name ) VALUES ( 'Cayman Islands' ); INSERT INTO Countries ( Name ) VALUES ( 'Central African Republic' ); INSERT INTO Countries ( Name ) VALUES ( 'Chad' ); INSERT INTO Countries ( Name ) VALUES ( 'Chile' ); INSERT INTO Countries ( Name ) VALUES ( 'China' ); INSERT INTO Countries ( Name ) VALUES ( 'Colombia' ); INSERT INTO Countries ( Name ) VALUES ( 'Comoros' ); INSERT INTO Countries ( Name ) VALUES ( 'Congo' ); INSERT INTO Countries ( Name ) VALUES ( 'Costa Rica' ); INSERT INTO Countries ( Name ) VALUES ( 'Croatia' ); INSERT INTO Countries ( Name ) VALUES ( 'Cuba' ); INSERT INTO Countries ( Name ) VALUES ( 'Cyprus' ); INSERT INTO Countries ( Name ) VALUES ( 'Czech Republic' ); INSERT INTO Countries ( Name ) VALUES ( 'Democratic Republic of the Congo' ); INSERT INTO Countries ( Name ) VALUES ( 'Denmark' ); INSERT INTO Countries ( Name ) VALUES ( 'Djibouti' ); INSERT INTO Countries ( Name ) VALUES ( 'Dominican Republic' ); INSERT INTO Countries ( Name ) VALUES ( 'Dominica' ); INSERT INTO Countries ( Name ) VALUES ( 'Ecuador' ); INSERT INTO Countries ( Name ) VALUES ( 'Egypt' ); INSERT INTO Countries ( Name ) VALUES ( 'El Salvador' ); INSERT INTO Countries ( Name ) VALUES ( 'Equatorial Guinea' ); INSERT INTO Countries ( Name ) VALUES ( 'Eritrea' ); INSERT INTO Countries ( Name ) VALUES ( 'Estonia' ); INSERT INTO Countries ( Name ) VALUES ( 'Ethiopia' ); INSERT INTO Countries ( Name ) VALUES ( 'Fiji' ); INSERT INTO Countries ( Name ) VALUES ( 'Finland' ); INSERT INTO Countries ( Name ) VALUES ( 'France' ); INSERT INTO Countries ( Name ) VALUES ( 'French Guiana' ); INSERT INTO Countries ( Name ) VALUES ( 'Gabon' ); INSERT INTO Countries ( Name ) VALUES ( 'Gambia' ); INSERT INTO Countries ( Name ) VALUES ( 'Georgia' ); INSERT INTO Countries ( Name ) VALUES ( 'Germany' ); INSERT INTO Countries ( Name ) VALUES ( 'Ghana' ); INSERT INTO Countries ( Name ) VALUES ( 'Great Britain' ); INSERT INTO Countries ( Name ) VALUES ( 'Greece' ); INSERT INTO Countries ( Name ) VALUES ( 'Grenada' ); INSERT INTO Countries ( Name ) VALUES ( 'Guadeloupe' ); INSERT INTO Countries ( Name ) VALUES ( 'Guatemala' ); INSERT INTO Countries ( Name ) VALUES ( 'Guinea' ); INSERT INTO Countries ( Name ) VALUES ( 'Guinea-Bissau' ); INSERT INTO Countries ( Name ) VALUES ( 'Guyana' ); INSERT INTO Countries ( Name ) VALUES ( 'Haiti' ); INSERT INTO Countries ( Name ) VALUES ( 'Honduras' ); INSERT INTO Countries ( Name ) VALUES ( 'Hungary' ); INSERT INTO Countries ( Name ) VALUES ( 'Iceland' ); INSERT INTO Countries ( Name ) VALUES ( 'India' ); INSERT INTO Countries ( Name ) VALUES ( 'Indonesia' ); INSERT INTO Countries ( Name ) VALUES ( 'Iran' ); INSERT INTO Countries ( Name ) VALUES ( 'Iraq' ); INSERT INTO Countries ( Name ) VALUES ( 'Israel and the Occupied Territories' ); INSERT INTO Countries ( Name ) VALUES ( 'Italy' ); INSERT INTO Countries ( Name ) VALUES ( 'Ivory Coast (Cote d' 'Ivoire)' ); INSERT INTO Countries ( Name ) VALUES ( 'Jamaica' ); INSERT INTO Countries ( Name ) VALUES ( 'Japan' ); INSERT INTO Countries ( Name ) VALUES ( 'Jordan' ); INSERT INTO Countries ( Name ) VALUES ( 'Kazakhstan' ); INSERT INTO Countries ( Name ) VALUES ( 'Kenya' ); INSERT INTO Countries ( Name ) VALUES ( 'Kosovo' ); INSERT INTO Countries ( Name ) VALUES ( 'Kuwait' ); INSERT INTO Countries ( Name ) VALUES ( 'Kyrgyz Republic (Kyrgyzstan)' ); INSERT INTO Countries ( Name ) VALUES ( 'Laos' ); INSERT INTO Countries ( Name ) VALUES ( 'Latvia' ); INSERT INTO Countries ( Name ) VALUES ( 'Lebanon' ); INSERT INTO Countries ( Name ) VALUES ( 'Lesotho' ); INSERT INTO Countries ( Name ) VALUES ( 'Liberia' ); INSERT INTO Countries ( Name ) VALUES ( 'Libya' ); INSERT INTO Countries ( Name ) VALUES ( 'Liechtenstein' ); INSERT INTO Countries ( Name ) VALUES ( 'Lithuania' ); INSERT INTO Countries ( Name ) VALUES ( 'Luxembourg' ); INSERT INTO Countries ( Name ) VALUES ( 'Republic of Macedonia' ); INSERT INTO Countries ( Name ) VALUES ( 'Madagascar' ); INSERT INTO Countries ( Name ) VALUES ( 'Malawi' ); INSERT INTO Countries ( Name ) VALUES ( 'Malaysia' ); INSERT INTO Countries ( Name ) VALUES ( 'Maldives' ); INSERT INTO Countries ( Name ) VALUES ( 'Mali' ); INSERT INTO Countries ( Name ) VALUES ( 'Malta' ); INSERT INTO Countries ( Name ) VALUES ( 'Martinique' ); INSERT INTO Countries ( Name ) VALUES ( 'Mauritania' ); INSERT INTO Countries ( Name ) VALUES ( 'Mauritius' ); INSERT INTO Countries ( Name ) VALUES ( 'Mayotte' ); INSERT INTO Countries ( Name ) VALUES ( 'Mexico' ); INSERT INTO Countries ( Name ) VALUES ( 'Moldova Republic of' ); INSERT INTO Countries ( Name ) VALUES ( 'Monaco' ); INSERT INTO Countries ( Name ) VALUES ( 'Mongolia' ); INSERT INTO Countries ( Name ) VALUES ( 'Montenegro' ); INSERT INTO Countries ( Name ) VALUES ( 'Montserrat' ); INSERT INTO Countries ( Name ) VALUES ( 'Morocco' ); INSERT INTO Countries ( Name ) VALUES ( 'Mozambique' ); INSERT INTO Countries ( Name ) VALUES ( 'Namibia' ); INSERT INTO Countries ( Name ) VALUES ( 'Nepal' ); INSERT INTO Countries ( Name ) VALUES ( 'Netherlands' ); INSERT INTO Countries ( Name ) VALUES ( 'New Zealand' ); INSERT INTO Countries ( Name ) VALUES ( 'Nicaragua' ); INSERT INTO Countries ( Name ) VALUES ( 'Niger' ); INSERT INTO Countries ( Name ) VALUES ( 'Nigeria' ); INSERT INTO Countries ( Name ) VALUES ( 'Korea Democratic Republic of (North Korea)' ); INSERT INTO Countries ( Name ) VALUES ( 'Norway' ); INSERT INTO Countries ( Name ) VALUES ( 'Oman' ); INSERT INTO Countries ( Name ) VALUES ( 'Pacific Islands' ); INSERT INTO Countries ( Name ) VALUES ( 'Pakistan' ); INSERT INTO Countries ( Name ) VALUES ( 'Panama' ); INSERT INTO Countries ( Name ) VALUES ( 'Papua New Guinea' ); INSERT INTO Countries ( Name ) VALUES ( 'Paraguay' ); INSERT INTO Countries ( Name ) VALUES ( 'Peru' ); INSERT INTO Countries ( Name ) VALUES ( 'Philippines' ); INSERT INTO Countries ( Name ) VALUES ( 'Poland' ); INSERT INTO Countries ( Name ) VALUES ( 'Portugal' ); INSERT INTO Countries ( Name ) VALUES ( 'Puerto Rico' ); INSERT INTO Countries ( Name ) VALUES ( 'Qatar' ); INSERT INTO Countries ( Name ) VALUES ( 'Reunion' ); INSERT INTO Countries ( Name ) VALUES ( 'Romania' ); INSERT INTO Countries ( Name ) VALUES ( 'Russian Federation' ); INSERT INTO Countries ( Name ) VALUES ( 'Rwanda' ); INSERT INTO Countries ( Name ) VALUES ( 'Saint Kitts and Nevis' ); INSERT INTO Countries ( Name ) VALUES ( 'Saint Lucia' ); INSERT INTO Countries ( Name ) VALUES ( 'Saint Vincent' 's & Grenadines' ); INSERT INTO Countries ( Name ) VALUES ( 'Samoa' ); INSERT INTO Countries ( Name ) VALUES ( 'Sao Tome and Principe' ); INSERT INTO Countries ( Name ) VALUES ( 'Saudi Arabia' ); INSERT INTO Countries ( Name ) VALUES ( 'Senegal' ); INSERT INTO Countries ( Name ) VALUES ( 'Serbia' ); INSERT INTO Countries ( Name ) VALUES ( 'Seychelles' ); INSERT INTO Countries ( Name ) VALUES ( 'Sierra Leone' ); INSERT INTO Countries ( Name ) VALUES ( 'Singapore' ); INSERT INTO Countries ( Name ) VALUES ( 'Slovak Republic (Slovakia)' ); INSERT INTO Countries ( Name ) VALUES ( 'Slovenia' ); INSERT INTO Countries ( Name ) VALUES ( 'Solomon Islands' ); INSERT INTO Countries ( Name ) VALUES ( 'Somalia' ); INSERT INTO Countries ( Name ) VALUES ( 'South Africa' ); INSERT INTO Countries ( Name ) VALUES ( 'Korea Republic of (South Korea)' ); INSERT INTO Countries ( Name ) VALUES ( 'South Sudan' ); INSERT INTO Countries ( Name ) VALUES ( 'Spain' ); INSERT INTO Countries ( Name ) VALUES ( 'Sri Lanka' ); INSERT INTO Countries ( Name ) VALUES ( 'Sudan' ); INSERT INTO Countries ( Name ) VALUES ( 'Suriname' ); INSERT INTO Countries ( Name ) VALUES ( 'Swaziland' ); INSERT INTO Countries ( Name ) VALUES ( 'Sweden' ); INSERT INTO Countries ( Name ) VALUES ( 'Switzerland' ); INSERT INTO Countries ( Name ) VALUES ( 'Syria' ); INSERT INTO Countries ( Name ) VALUES ( 'Tajikistan' ); INSERT INTO Countries ( Name ) VALUES ( 'Tanzania' ); INSERT INTO Countries ( Name ) VALUES ( 'Thailand' ); INSERT INTO Countries ( Name ) VALUES ( 'Timor Leste' ); INSERT INTO Countries ( Name ) VALUES ( 'Togo' ); INSERT INTO Countries ( Name ) VALUES ( 'Trinidad & Tobago' ); INSERT INTO Countries ( Name ) VALUES ( 'Tunisia' ); INSERT INTO Countries ( Name ) VALUES ( 'Turkey' ); INSERT INTO Countries ( Name ) VALUES ( 'Turkmenistan' ); INSERT INTO Countries ( Name ) VALUES ( 'Turks & Caicos Islands' ); INSERT INTO Countries ( Name ) VALUES ( 'Uganda' ); INSERT INTO Countries ( Name ) VALUES ( 'Ukraine' ); INSERT INTO Countries ( Name ) VALUES ( 'United Arab Emirates' ); INSERT INTO Countries ( Name ) VALUES ( 'United States of America (USA)' ); INSERT INTO Countries ( Name ) VALUES ( 'Uruguay' ); INSERT INTO Countries ( Name ) VALUES ( 'Uzbekistan' ); INSERT INTO Countries ( Name ) VALUES ( 'Venezuela' ); INSERT INTO Countries ( Name ) VALUES ( 'Vietnam' ); INSERT INTO Countries ( Name ) VALUES ( 'Virgin Islands (UK)' ); INSERT INTO Countries ( Name ) VALUES ( 'Virgin Islands (US)' ); INSERT INTO Countries ( Name ) VALUES ( 'Yemen' ); INSERT INTO Countries ( Name ) VALUES ( 'Zambia' ); INSERT INTO Countries ( Name ) VALUES ( 'Zimbabwe' );

Laxmidhar Sahoo · Answer

sir the list is in which format ? In Which database u want to insert?

Nitin Sontakke · Answer

Hello @Abdalmajeed Can you please post the line here which will insert a single record in you db? In my Excel I had already provided part of the SQL.

Ajeesh · Answer

You can use the SQL Sever Import Wizard to Import data from Excel

Abdalmajeed Alshari · Answer

I am Use SQL Server DB Now How to import the excel file into My DB

Ramesh Palanivel · Answer

Hi Please upload it from Excel or Access. To download country details please refer the below Link http://www.statvision.com/webinars/countries%20of%20the%20world.xls

Nitin Sontakke · Answer

You can even go to https://en.wikipedia.org/wiki/ISO_3166-1 The select the table you want to copy and paste it in MS-Excel and prepare the script with the help of a simple formula. See Excel attached with my previous post.

Nitin Sontakke · Answer

See the attached imported from http://www.nationsonline.org/oneworld/country_code_list.htm Open Microsoft Excel click on Data and then 'From Web'. A window opens paste the link there and press 'Go'. A web-page appears in the window. Click an yellow arrow next to a table you want to import and click OK.

Nitin Sontakke · Answer

Which database you have? SQL Server Oracle etc. and it's version?

Bharathi Raja · Answer

http://www.worldcitiesdatabase.com/world-cities.aspx