>>>>>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).