Hi,
A new web application project that I am involved with requires a great deal of database orientated work. Unfortunately most of the data is stored in MS Excel format (why the client did this I don't know....)
I suspect that the answer is 'no', but is it possible to query an Excel database as one would an SQL database, and thus directly integrate Excel into a web application (using PHP in particular)??
I am looking at any possible alternative to migrating the data (of which there are a full year's worth of populated tables), from excel to MySQL.
Keeping both cost and time down to a minimum is a priority. This is why I would rather retain the existing Excel database format if at all possible....
I know that this is a long shot! I am used to working with PHP and SQL, but Excel is quite foreign to me, so I am unsure of its limitations....
If I want to have the flexible functionality that one gets with SQL driven databases, will I need to migrate, as I fear, the entire data population from Excel to SQL?
Help
Thanks
Will
Linear Mode
