Hi, I have been asked to investigate ways of simplifying and speeding up the process of adding and updating data held in wp data tables for display on the http://www.ww1bradford.org/ website e.g table: http://www.ww1bradford.org/those-who-served-and-died/ .

The site currently uses version 2.0.2 and the purchase code has expired so looking to see if it is worth renewing to get the following functionality.

The user would like to make changes to the data on an excel spreadsheet locally and then upload this to the server REPLACING the data held in the current associated wp data table thereby automatically update the data displayed on the website. In effect synchronising the excel spreadsheet with the wp data table. 

As far as I can make out it seems that it is not currently possible to upload replacing a table, it's only possible to upload creating a NEW table.

Am I correct?... 

please can you suggest a recommended method, the current method of editing on the website is undesirable especially with the proposed implementation of a new table which will have around 40,000 rows.

One option if it cannot be done through wp data tables might be to find a plugin that can upload csv format directly into the relevant mySQL table perhaps.

Thanks

Pete