Automate excel data on daily base in database?

Help Automation Hub
1

Hi,
how to do, i want to insert 1k excel data on daily basis in sql server database. how to automate ?
please help how i start to solve this problem please help and suggest how to do that…

  1. insert excel data in database daily
  2. need to delete old data in database
  3. add new excel file on folder so they can direct take from
2

please help i need to do very urgent

3

Hi @ANSARI_TAHIR ,

You can try bulk insert concept in sql, please refer below link

Regards,
Arivu

4

i want daily basis and no need to human intervention. i have excel file…
you share which is not going to help

5

Its not an human intervention you can achieve through UiPath.
You need to create procedure in sql and you need to call through UiPath refer the above link and follow the same in UiPath

6
7

HI @ANSARI_TAHIR ,

This will help you.

https://docs.uipath.com/activities/lang-en/docs/bulk-insert

Regards
Balamurugan.S