Hi
how can i import an excell file to a mysql db directly? or do i have to hire someone for data entery?
thanks
import from excell file
Moderator: General Moderators
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
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.
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.