SidC SidC - 14 days ago 9
MySQL Question

How to Upload Excel File to Single MySQL Table?

I've seen lots of examples of bulk uploading CSV files to MySQL. However, I have the need to utilize an Excel file, and don't want to trouble the user with saving as CSV. Can anyone provide links to PHP routines they use that will read large Excel files, match the column names to database table columns and upload large (>5k records) efficiently?

Thanks much!

Answer

You'd need to use something like PHPExcel to read/parse the Excel files. As for mapping columns to tables, that depends entirely on if the user actually bothers to put column headers into the spreadsheet. If they don't, then you'll just have to guess and it'll undoubtedly NOT work out nicely.

Allowing arbitarirly formatted spreadsheets anywhere near a database makes me cry...