Page 1 of 1

import from excell file

Posted: Wed Nov 07, 2007 11:04 am
by m2babaey
Hi
how can i import an excell file to a mysql db directly? or do i have to hire someone for data entery?
thanks

Posted: Wed Nov 07, 2007 11:54 am
by CoderGoblin
Hopefully you will get more responses than just me but in the past I used a module from Perl module from CPAN. It was some time ago and there are more modules to investigate now. You may also want to use your favourite seach tool and look for Excel Readers.

If you can simply save the Excel files as a CSV file you could use fgetcsv() to get the information which should be a relatively simple bit of PHP code.

A lot depends on what the CSV file contains.