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 :lol: :? :?: :idea:

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 :lol: :? :?: :idea:
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