Retrieving specific data from uploaded file & enter into

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
sanfrank
Forum Newbie
Posts: 1
Joined: Mon Oct 18, 2004 7:22 am

Retrieving specific data from uploaded file & enter into

Post by sanfrank »

Actually, I need to upload an excel file on clicking submit button, after which
specific data fields from the uploaded file have to be retrieved and these data have to be saved in a database. Could anyone help me with this query as I don't get any hunch of how to do this.
PHP experts, please reply !
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

You just have to parse the excel file or have it converted to a csv. Once the file is uploaded onto your server you can just open and read it - and do what you like. The only hard bit is working out the format/encoding of an excel file.
Post Reply