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
IBM/Lenovo T43 2687DSU
Pentium M 2.0Ghz
1024 MB (DDR2 SDRAM)
80 GB Ultra ATA, 5400 RPM
Windows XP Pro
64MB ATI MOBILITY RADEON X300
Integrated 802.11A/B/G, Bluetooth, 10/100/1000 Eth.