Hi
What if I want to upload an excell file and have its data automatically stored in a database?
thanks
excell to db
Moderator: General Moderators
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

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.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![]()
![]()
![]()
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