Important an Excel spreadsheet in to SQL database

[mnymkr]

How might we import an excel spreadsheet into a sql database?

[void]

I'd save the Excel file as .csv and then import using something like phpMyAdmin.

[mnymkr]

ok what if i need for someone who does not have phpmyadmin access to do it

[sarahk]

Create a script to read the csv file, parse it into an array and then create the insert statements.

see http://www.php.net/fgetcsv