If you've created a table linked to an existing CSV file, the only way to update it would be to update the CSV file in ../wp-content/uploads/YEAR/MONTH/ - that has been used to create the table.
When you modify the file, please keep in mind that the structure needs to remain the same, so you cannot rename columns, change the order of columns, delete columns or add new columns, or the table will break.
On the other hand, if you have a manual table, you can locate that table in the database, and through PHPMyAdmin import the data from the CSV file directly in that table. Again, the structure needs to stay the same.
Hi,
Is it possible to import data from a cvs. file to a table that already exists?
Hello Joy
If you've created a table linked to an existing CSV file, the only way to update it would be to update the CSV file in ../wp-content/uploads/YEAR/MONTH/ - that has been used to create the table.
When you modify the file, please keep in mind that the structure needs to remain the same, so you cannot rename columns, change the order of columns, delete columns or add new columns, or the table will break.
On the other hand, if you have a manual table, you can locate that table in the database, and through PHPMyAdmin import the data from the CSV file directly in that table. Again, the structure needs to stay the same.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables