Delete All Rows in Table -- Not Deleting All Records
I am trying to delete all the rows in an Excel table and reinsert new records into the table with data from SQL. I have done the popular List All Rows, then Delete A Row using a Key Field from the List All Rows step above.
This worked fine, but now I am at 500+ rows (and my # of rows will continue to grow) and either the List or Delete step seems to time out before it removes all rows. I have tried adding some delays in there which helped a little, but my automation is losing its efficiency.
Has anyone else run into this issue? Is there a way to delete all the rows in a table at once?