Page 1 of 1
excell to db
Posted: Mon Jul 23, 2007 9:14 pm
by m2babaey
Hi
What if I want to upload an excell file and have its data automatically stored in a database?
thanks
Posted: Mon Jul 23, 2007 9:31 pm
by feyd
Sorry?
Posted: Mon Jul 23, 2007 9:52 pm
by m2babaey
database tables have fields and data is stored in them.
Microsoft Excell files have fields and again data is stored in them.
I meant for entering data from excell files to database, instead of inserting all the data manually one by one, is there a way we give the excell file to php and php enters its data into the database

Posted: Mon Jul 23, 2007 10:04 pm
by boo
m2babaey wrote:database tables have fields and data is stored in them.
Microsoft Excell files have fields and again data is stored in them.
I meant for entering data from excell files to database, instead of inserting all the data manually one by one, is there a way we give the excell file to php and php enters its data into the database

I wound go with a CSV file and then parse the file and enter the records into the table (or tables) that you need to.
You can just save the excel file as a CSV then create a form to accept the file (check file type) then read through the file and add the records to the database