zimvoter:

A few notes...

By the error message, you likely have a column with a single-quote in it. (Such as a last name of O'Brian.)

You're likely in the wrong place, as this isn't a PHP board.

You might consider using the quoting facility in your language/library of choice and using that instead of building the insert statements on-the-fly. (Just a guess.)

Since the data is also in Excel, you *could* write a quickie VB script to export the data into MySQL...

Finally, there's an ODBC interface to Excel, so you might be able to write a quickie PHP program to open the spreadsheet and copy the values over to the MySQL DB.

...roboticus