Deleting/Reimport/Copying Tables

Hi, first of all, this is what Ive been looking for, the speed of loading is very impressive with the amount of data I publish. I will not name the other plugin I used but this loads on my site in around 6 seconds as opposed to 45 seconds with the other plugin.

So in relation to this, is there anyway to empty a table of the rows with data in. I currently have 4000 rows and need to update virtually every day.

I tried to upload a new (update) data set, but this just appends the data and doesn’t overwrite the existing data – understandable.

The problem is I then have 8000 rows of data. I tried deleting all rows, but it only allows 100 maximum at a time – unless I’m missing something.

I know I can export a blank table and reimport it, then add the data, but all a bit long winded.

In short,
A) is there a way to delete all rows in one go?
B) is there a way to overwrite data rather than append it?

Thankyou in advance.