how to import excel file in sql server

uiautomation

#1

how to import excel file in sql server ?


#2

Hi @Maheshwar_Matalwar,

you can do it directly in SQL server itself using import option as one time activity, check the below link

And if you have to do anything with the data before importing in UiPath elaborate your question please.


#3

thank you …’

i knw how to import manually …
bt this activity i want again ad again …is uipath can do automatically ?


#4

Yes you can do it, read the excel file using Read Range Activity. Then use the below activity to insert/update data in database.
Capture


#5

please elaborate with simple example …
how to import excel in database and execute operation save result in excel …