I want to get data from excel file and insert it into db,is there anything help about this?

[mikeji]

I want to get data from excel file and insert it into db,is there anything help about this?

[fenway]

Sure... use LOAD DATA LOCAL INFILE, and specify appropriate field/row terminators for a TAB-delimited / CSV-export from your Excel file. I'm sure I've posted something like that here before; I don't remember the syntax off-hand.

[wickning1]

If you need to do a lot of translation, you may have to read the CSV in PHP and create an SQL query on the fly. You can use the PHP functions file() and explode() to easily parse a CSV file.. You'll have to export to CSV in Excel.

Example:
[code]foreach(file('mycsvfile.csv') as $line) {
   $row = explode(',', $line);
   $datayouwant = $row[5];
   $moredatayouwant = $row[7];
   ... INSERT ... ($datayouwant, $moredatayouwant) ...
}[/code]