Ok so I have a database storing staff contact information that will be dynamically pulled within a PHP script depending on certain criteria...
everytime a staff member is changed I would have to go into the table and add/remove/edit the fields effected, I just don't have the time to effect such changes and training another employee in database technologies is a disaster waiting to happen...
so my goal is to have a Excel/OpenOffice spreadsheet that will open the database content and allow for the applicable changes and when the spreadsheet is saved the changes are written back to the database
Does anyone have any experience in this area or know where I can find a guide on the general topic, I have sucessfully created an ODBC link and have been able to browse the database using Components of OpenOffice
-t1
everytime a staff member is changed I would have to go into the table and add/remove/edit the fields effected, I just don't have the time to effect such changes and training another employee in database technologies is a disaster waiting to happen...
so my goal is to have a Excel/OpenOffice spreadsheet that will open the database content and allow for the applicable changes and when the spreadsheet is saved the changes are written back to the database
Does anyone have any experience in this area or know where I can find a guide on the general topic, I have sucessfully created an ODBC link and have been able to browse the database using Components of OpenOffice
-t1
