Jump to content

Archived

This topic is now archived and is closed to further replies.

mikeji

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

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.