Compare and Update database from excel spreadsheet

futhonguy 0 Junior Poster in Training

14 Years Ago

Hi people,

I have a huge data stored in my database server and am currently trying to work out a script in order to update my data in the server.
This update comes from an Excel spreadsheet.

I did search on Google/Yahoo and found websites like PHPExcelReader or PHPExcel. My idea was to read from the spreadsheet and stored the information into the database server. from there, then to compare with the existing data and should there be any changes, it will automatically update the existing data with the new information from the spreadsheet. I am not sure if this is the right approach to do it. If there are other information/resources, can someone willingly to share with me?

Also it will be best if there are examples as well.
Thanks guys
Cheers

php

1 Contributor
0 Replies
64 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.