import excel to mysql

[eluser]Dam1an[/eluser]
Here's a high level overview of a possible solution
1) Export from Excel to CSV
2) Read file into array of lines using the file() function
3) For each line, explode on comma and build the insert query as needed
4) Execute query, inserting that row
5) Rinse and repeat

I can see one instant flaw with that, being if the speadhseet keeps the old data after an import, it will try to import it again, so you'll need to check on PK (maybe get the IDs of all the PKs into an array at the start, and check if the ID exists in that array before inserting, of course this won;t work for auto incrementing IDs, so you would need to check the whole row)