>>>>>>Does anyone have any idea where to get a data file of countries by continent
>>>>>
>>>>>Check Downloads #37408
>>>>>
>>>>>https://www.levelextreme.com/ViewPageNewDownload.aspx?ID=37408
>>>>
>>>>It doesnt give me the continent or am I missing something?
>>>>
>>>>Thanks
>>>>
>>>>Colin
>>>
>>>Yes, this is just a list of all countries. You probably can add continent yourself.
>>
>>OK - How do I turn it into a table?
>>
>>Thanks
>
>This is a script for creating a table (with extra columns you may not need) in SQL Server. You can run it there and then export data into a table (you can use Excel as intermediate step).

Thanks

Colin