Insert Excel Data to MS-SQL

[ym.shin]

Hi, everyone.

I just want to ask you how to insert excel data to ms-sql.

I just downloaded the package, ‘UiPath.Database.Activities’,

but cannot find any activity to insert from the activity panel, only the ‘Connect to Database’ and ‘Disconnect from Database’

Please help…

[ashokkarale]

@ym.shin,

Follow this solution.

Bulk insert and Insert DB in Uipath

In UiPath, you can perform bulk insert and single insert operations to a database using the Database activities package. You can use the Insert activity for single inserts and the Execute Non-Query activity for bulk inserts. Here’s how to perform a bulk insert and a single insert operation in UiPath: Install Database Activities Package:a. Open your UiPath Studio. b. Go to the “Manage Packages” button on the top right corner. c. Search for “UiPath.Database.Activities” and click Install, then…

Thanks,
Ashok

[mkankatala (Mahesh Kankatala)]

Hi @ym.shin

You can use the Bulk Insert activity to insert the bulk excel data to the Database.

Follow the below video and check the documentation,

Activities - Bulk Insert

4. Bulk Update Data in Database with UiPath | Excel to Database in UiPath | Database Automation

Hope it helps!!