Hi,
If you save the Excel file as tab limited file or 'Text (Tab delimited) (*.txt)', you can then import it into an existing MySQL table either through a query in MySQL Query Browser or equivalent, or write a script to do that.
Here is an example of the query that does the import from the c:\temp folder of the local workstation, which is not the same as the MySQL server:
LOAD DATA LOCAL INFILE "c:/temp/example.tab.txt"
INTO TABLE `my_database`.`my_table`
IGNORE 1 LINES
For more info, check out the MySQL reference manual at [
dev.mysql.com]
PHP has functions to read CSV (comma separated value) files, but saving Excel spreadsheets as CSV files produce inconsistent results if some of your alphanumeric fields have commas. I found tab limited files easier to handle. You may still have to write an import script to convert the values like remove quotation marks from alpha fields.
Regards,
toivo
Sydney, Australia