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.