Datatable from excel to ms-sql data table

[Povilas_Jonikas]

Hello guys, so i’ve just started to work on my new project - Scrappe data, take the data table and insert it to MS SQL datatable. But I don’t even imagine where to start. I downloaded ODBC Data Source Administrator, but what now? I know that i’m asking for a lot of help, but could you guys be pleasing enough to tell me how and what should I do next? Any information would be appreciated.

[arjunshenoy]

Hi @Povilas_Jonikas

The following resources might help you with the specified requirement:

How to insert a datatable into SQL Server database using Uipath database activities?

I have a datatable DT with 25 columns. I want to insert that data from DT into a SQL Server table SQDT with the same columns. I’m using an INSERT query for now. Is there a better way to approach this problem instead of using INSERT on each record? Can I bulk insert into the database using a stored procedure or some other efficient way? It takes a lot of time to insert as DT has 130000 tuples.

3. How to Insert Data in Database with UiPath || Excel to Database in UiPath | Database Automation

Hope this helps,
Best Regards.

[Povilas_Jonikas]

Thanks, ill look into it