I have a spreadsheet in a O365 group document library.
Every day aat 3am I want to dump contents of the SQL table and rebuild from Excel table.
How do I delete all the records in an existing SQL table and iterate thru the rows of an excel table in an excel file we store in a groups documnt library, and simply insert those rows to the table?
I cannot find 1 example of this online? Anyone out there done this.
Im playing with Excel List all rows and then Apply To Each/ Get Rows in SQL Action. But I am not ssure howw to configure and use. It runs but just spins forever.
Im new to flow but work with SSIS and SQL all the time. Its just a pain to work with Sharepoint group files from SSIS so I am experimenting with FLow. I like the tool but Im suprised that I cant find examples of this?
Thx,
Joe