Import CSV into SQL Database Server using Power Automate Desktop
Рет қаралды 4,857
Күн бұрын
@jensheesch1856 2 ай бұрын
Awesome like it, thanks for sharing.
@valeriastrafe5104 7 ай бұрын
Thank you for sharing this... you have no idea how long it has been since I was looking for exactly this!!!!
@kdspland 6 ай бұрын
Can't wait to try this out.
@xnbet 10 ай бұрын
Awesome!
@sujarw2093 2 ай бұрын
Thank you so much. It worked. However, I need to know I have 60000 records and it is taking lot of time around 10 min. Any work around to increase the speed without using for each loop
@AIPSolutions 2 ай бұрын
You can try splitting the data into smaller batches and processing that way to see if speed improves. Or even feed the logic of your flow into ChatGPT and see what it says on how to improve, if it can be.
@acaphamzah 6 ай бұрын
Thanks for your informative video. I have a question. How do insert into sql only newly added items in csv?
@AIPSolutions 6 ай бұрын
You would have do do a comparison of the database and the csv then insert the differences. If the csv is a master sheet and will always be in order, get the last entry in the database then find that entry in the spreadsheet and insert everything below that point in the sheet.
@shyamn7998 Жыл бұрын
Thanks for sharing useful info, their is any other way to avoid the use of PowerAutmate or any other easy method from Sql Server management studio to import data from xls to Slq Server table automatic/scheduled.
@AIPSolutions Жыл бұрын
Your welcome! Yes there are multiple ways to get this done, I will do a video showing how to do this using PowerShell and Python
@priyal_001 9 ай бұрын
Can this same thing happen in web access like without desktop. Please if you can give some hint
Last Minute Coders
Рет қаралды 13 М.
Power Automate Desktop || Module 6 : Database (Open and Close SQL Connection, Execute SQL Statement)
Learning RPA Technologies
Рет қаралды 44 М.
Harley Quinn with the Joker
Рет қаралды 25 МЛН
Learning RPA Technologies
Рет қаралды 10 М.
Ryan & Matt Data Science
Рет қаралды 11 М.
Shark Zhan
Рет қаралды 31 МЛН
АЙДЕН
Рет қаралды 316 М.