Announcements
Hello,
I am trying to insert multiple rows(more than 10000) in Database. it will takes much more time. I would like to achieve it in a few seconds.
Can any one share their experience on what is the fastest way to do it?
Write the Datatable to Excel (or it is already in Excel) and then try out the SQL command such as
BULK INSERT
https://www.mssqltips.com/sqlservertip/6109/bulk-insert-data-into-sql-server/
@VJR @Anonymous
If you’re moving things to a SharePoint list, then you could also try this template for bulk data transfers from files to SharePoint lists: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Automate-Reports-From-External-Datasources/td-p/1486023
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 227 Super User 2026 Season 2
David_MA 213 Super User 2026 Season 2
Mohsin Ali 151
