how to transfer updated sql excel automatic on every half an

You will find cron job in your server(wherever you hosted your website e.g. godaddy or hostgator). Set-up cron by giving link of your online hosted page.

such as www.sample.com/mysamplepage.aspx and set time.

Now there are multiple code available on net to convert datatable to excel and similarly to load it on your ftp server.

Sk Jha8y ago

Any example how to do this

Rajneesh Chaubey8y ago

You can setup cron job to accomplish this task. You can create a page which when loads, will get your data in datatable and convert that in excel and at the same time load(save) it on your ftp server. Cron job will run the page every half an hour.