hello,
How do I provide an excel front end to a php/mssql 'backend'. Basically, I want to retreive and modify data from a database over php. However for the users there must be an excel interface. Is this possible? I know how to display excel through html, and it can even be modified on screen. But I would like these modifications to update the database. Any ideas?
Thanks in advace Gareth
Import/Export using CSV files ->
Dump from MySQL into CSV file Import CSV into Excell Edit Save as CSV Import back again.
A lot can go wrong when keys are changed, so be careful with updating without checking.
thanks, I can do this step by step, manually - what I was after is to automate the process - completely. Can this be done?
You loose control over the process once the user is interacting within Excell, except if you would like to start programming macro's there. (not something I enjoy). In that case you also need to use ODBC to upload the data back to MySQL. Doable but tricky.
