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.
@jensheesch1856
2 ай бұрын
Awesome like it, thanks for sharing.
@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
10 ай бұрын
Can this same thing happen in web access like without desktop. Please if you can give some hint
Пікірлер: 11