how to convert excel file into mysql using php?

1 ⤊

how to convert excel file into mysql using php?

how to convert excel file into mysql using php. i believe this can be done? if so, where can i find such information? thanks!

2007-07-27 05:33:25 · 1 answers · asked by i want to learn php 1 in Computers & Internet ➔ Programming & Design

1 answers

There's really no need to. First, export data out of Excel into a comma-separated or tab-delimited text file. Then, import it into MySQL with a LOAD DATA INFILE query.

2007-07-27 05:59:17 · answer #1 · answered by NC 7 · 1⤊ 0⤋