# How to insert a datatable into SQL Server database using Uipath database activities? **URL:** \ **Category:** Activities\ **Tags:** database, activities\ **Created:** [September 22, 2020, 10:13pm UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663 "2020-09-22T22:13:51Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Renan\_Souza](https://avatars.discourse-cdn.com/v4/letter/r/cdc98d/32.png) [@Renan\_Souza](https://forum.uipath.com/u/Renan_Souza)\ **Post date:** [September 22, 2020, 10:13pm UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663/1 "2020-09-22T22:13:51Z")
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. ---
**Author:** ![TimK](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/timk/32/264334_2.png) [@TimK](https://forum.uipath.com/u/TimK)\ **Post date:** [September 22, 2020, 10:27pm UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663/2 "2020-09-22T22:27:44Z")
There is a insert datatable activity, you must make sure all columns and datatypes are matched. So the datatable in uipath and database must have the same number of columns etc. A good way to ensure the dt is correct format is to do a select statement om the dt. Select top 0 \* from dt. This returns a blank datatable with the headers. ---
**Author:** ![Luis\_Martirena](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/luis_martirena/32/181327_2.png) [@Luis\_Martirena](https://forum.uipath.com/u/Luis_Martirena)\ **Post date:** [February 10, 2021, 3:52pm UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663/4 "2021-02-10T15:52:55Z")
Hello Tim, i don’t see the Insert Data Table activity, I don’t have it. I google it to check which package have to be installed, but couldn’t find anything. Can you tell me which package needs to be installed in order to have it? Thank you very much! ---
**Author:** ![bilal](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bilal/32/177661_2.png) [@bilal](https://forum.uipath.com/u/bilal)\ **Post date:** [February 11, 2021, 11:21am UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663/5 "2021-02-11T11:21:12Z")
You could use the insert datatable activity by installing the following package: Uipath.Database.Activities ---
**Author:** ![Luis\_Martirena](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/luis_martirena/32/181327_2.png) [@Luis\_Martirena](https://forum.uipath.com/u/Luis_Martirena)\ **Post date:** [February 11, 2021, 1:36pm UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663/6 "2021-02-11T13:36:03Z")
Thank you very much!! ---
**Author:** ![ankit.jain2](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ankit.jain2/32/176627_2.png) [@ankit.jain2](https://forum.uipath.com/u/ankit.jain2)\ **Post date:** [November 18, 2021, 9:15am UTC](https://forum.uipath.com/t/how-to-insert-a-datatable-into-sql-server-database-using-uipath-database-activities/257663/7 "2021-11-18T09:15:00Z")
@Renan_Souza do you get solution for this?