UIPATH Bulk Insert data from excel SQL | UIPATH Bulk Upload | UIPATH Data Table to SQL data table

#uipath #uipathdatabase #uipathbulkinsert #uipathbulkupload #exceltosqldatabase #uipathsql

00:00 UIPATH Bulk Data Upload Intro
02:40 UIPATH SQL Connection String
03:00 UIPATH BULK Insert

RPA PROJECTS PLAYLIST

[devandevan]

Sir, I I'm getting error as the provider columns in the data table do not match the column data types in the database. Even when the column name is same, tell me what should I do with the datatpye.

[tushar]

With the insert activity data successfully added in database but same thing i am doing with bulk insert its give an error ""Bulk insert: The provided columns in the DataTable do not match the column data types in the database.""

[nevilledoke]

for example u have 1 excel sheet and it consist of 10000 data in it. Later when we import that excel file in pycharm or jupiter notebook. if i run that file i will get an Index range also know as Row labels. my python code should be able to read that ten thousand row labels and should be able to separate / split into 10 different excel sheet files which will have 1000 data in each of the 10 saperated sheet.
other example is, if there is 9999 data in 1 sheet then my python code should divide 9000 data in 9 sheet and other 999 in other sheet without any mistakes.





i am asking this because in my data there is not any unique values for my code to split the files using .unique





plz help i have search the whole YT, stackoverflow, and github tooo from 3 days

[catstuff]

Please do realtime project using REframework too...

[sayandas]

Hello sir... How you find the Bulk insert activity means which package will need to be installed in it.. Because I am unable to find the activity in uipath needs your help to complete my automation project