upload XLS to MySQL table that has an ID field

Topics: User Forum
Dec 7, 2014 at 9:26 AM
Hi There,

I have managed to get PHPExcel working but I have a couple of issues.

My XLS spreadsheet has 7 columns but my MySQL Table has 8 it has an ID column so when I import to it my data is out of sync with the columns. How do i add a dummy field in the INSERT INTO statement?

Also do I really need to know how many rows are in my XLS spreadsheet? I am exporting my XLS from another application and the amount of rows is continually growing.