We have an apartment/design studio in Shenzhen, China, an office in Los Angeles and home in Chicago.

We have our Routerboards in China (China Telecom) our Los Angeles office (Time Warner) connected via PPTP to transfer extremely large files between the studio and the office. I also have a Routerboard in a Chicago home (AT&T / DSL) so I can watch real English TV and sometimes download a DVD from my collection -- which works great.

This is my problem. I now have this very good VPN provider that is stable with Extremely fast connections to the USA. I get great speeds for what I need to do (such as download files) and access certain web sites that China would otherwise block or slow down to crawling speeds, such as Gmail. (Gmail got so bad in China we gave up and used another provider).

I found a list on the internet of all IP blocks/ranges assigned to a specific country. See http://www.nirsoft.net/countryip/

I want to route ALL US/Canada IP addresses over the PPTP connection via the VPN. I can't seem to figure out how to route EVERYTHING destined to a particular public IP address range over the PPTP VPN connection. Ideally, I just route all traffic bound to the US over the PPTP VPN.

Any suggestions please let me know.

First, the format of the netblocks you get from that site are not nice for your application. You'll have better luck starting from a CIDR format list.

https://www.countryipblocks.net/

For a test I used the CIDR aggregation script and got a file with one netblock per line.

Then it would be need to be manipulated into a format which you can use to insert routes into the mikrotik.
How you do that depends on your scripting language of choice.

You want to output a line for each CIDR bock the ${ } is a variable notation I use a lot in sh scripting. Use whatever format works for your scripting language. It's probably possible to do it on the MikroTik itself. MikroTik scripting is help is in the MikroTik wiki. I spend all of my time on Unix boxes with sh available...
I put the addresses in a file called new_US_Allow.txt. I assumed your pptp interface is named pptp-usa.

In sh, it would be: You can upload the list in a blahblah.rsc file to the MikroTik and import it, or you can copy and paste it into an ssh session on the MikroTik.

The comment just helps you quickly delete all of the old entries, if you update the list. That's what the first line of the script does. It writes the command to delete every route with a comment of "USA" as the first line of the output file.

This is extremely helpful information, thanks. Especially the CountryIPBlocks web site -- exactly what I needed in the format I need it in. It gave me another idea that I can redirect web traffic from specific countries -- as we have a problem with people copying our designs from China/Hong Kong/Taiwan and other Asian countries -- we can just deter them by redirecting them all away.

Thanks again for the help.

Thank you very much for your input.

Could you as well show us the configuration regarding DNS, Routes, ...

Kind regards