Excel data upload in sql

We have to insert excel data in sql but because of data is 3 lakh it is taking to much time to insert how we can upload data in chunks …

Did this help you buddy

Cheers @Gauri_Rawool

@Gauri_Rawool Is it a .csv file or an .xls or .xlsx file?

.xlsx file

can u share me the workflow

@Gauri_Rawool Have you tried using Insert Activity from Database Activities?

yes i am using insert activity…it is taking to much time

@Gauri_Rawool How long does it take ?

@Gauri_Rawool I don’t think Insert Activity takes more time, I guess reading the Excel File Using Read Range takes more time