Hi everone. I was tired to type in a list of data in excel format and now retype into mysql. So Someone knows how to export excel file into mysql file or into mysql database server. Thanks for help.
No simple way. Export your data into CSV file and write a script to parse the data. Read in a line, split it up into individual values then insert them. Rinse and repeat.
There was a post not long ago about extracting data from Excel. There was (I think) a PEAR library available to PHP. I haven't run across it though (not really looking either). I found Perl has an awesome Excel reading library which worked great for what I needed.
