import from excell file

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

import from excell file

Post 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
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post 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.
Post Reply