How about import the data in a local SQL database and use data sync services to connect Local SQL Db ( On earth SQL ) To SQL Azure DB? This way you can setup your sync frequency.

Apart from that I would've thought if you have the correct native client driver on your Server then the normal import / export would work?