Bulk insert excel data into SQL Server DB

Help Studio
, ,
1

Hi Team,

I have a requirement to insert 5lac+ of rows to be inserted from excel to db. how to make it possible? and each and every month new file will be received and we need to read that file and store in datatable and insert into the existing db and perform remove db duplicates.

any easy solution from UiPath?

Regards,
Ritesh

2

@Ritesh_Burman,

Follow this approach.

  1. Use Read Range to read the excel file.
  2. Use Remove Duplicate activity to remove duplicate rows.
  3. Use Bulk Insert activity to insert data in bulk
  4. Consider breaking the DataTable into smaller batches (e.g., 50K rows at a time) and then executing the bulk insert for each batch. This can help avoid memory issues or long-running transactions that might impact the DB server.
3

@Ritesh_Burman

If data loader option is there for sql then better to create a script for that and trigger the script from UiPath

Cheers