European countries comma delimited file

[IBM]

Just too much hastle to do by hand, so does anyone have a comma delimited or excel file with a list of all European countries so I can drop it into SQL?

thanks

[Jonny M]

Do you want European countries, EU countries, or Eurozone countries?

[IBM]

European countries

[Iain]

It's not just European countries but heres the .csv for a large number of countries

http://www.hexus.net/iain/countries.csv

and in the offchance you're using MySQL here's the SQL to set up a table called countries with the data in it

http://www.hexus.net/iain/countries.sql

[IBM]

Cheers for that Iain, useful resource, but striping out all the irrelevant countries is almost as much work as inserting the relevant ones manually, so I'll going to keep holding my breath....

[Iain]

In that case Wikipedia is your friend

http://en.wikipedia.org/wiki/List_of...s_by_continent