Post reply

Best way to import excel data to sql azure and schedule - continous import

  • May 26, 2015 at 2:18 am

    #300962

    Hi All,

    What will be the best option for be to continuously move data from excel to sql azure.

    I know SSIS can do it if on premises but its not an option here.

    Would appreciate it if I can get some ideas...

    Thanks in Advance

  • June 2, 2015 at 7:45 am

    #1802304

    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?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply