wright67uk Posted December 23, 2012 Share Posted December 23, 2012 Does anyone know how, I can interact with an excel database? I would like to pull certain info from an excel sheet and display in a website. The excel sheet is offline and is updated numerous times each day, and I would only want a couple of columns to be displayed online. Am I looking at a VB and php mix? Maybe I could upload everytime the excel sheet is saved? Any advice or suggestions? Apologies for the post being in this Forum IF php doesn't come into it. Quote Link to comment Share on other sites More sharing options...
Christian F. Posted December 23, 2012 Share Posted December 23, 2012 First off: Excel is a spreadsheet, not a database. Though it may be abused and treated as one, it's far from being an actual database. The best advice would be to replace the spreadsheet with a proper database, if possible. The easiest way to do this, is to export the spreadsheet as a CSV, build the proper database structure, and then import it (via a PHP script, if necessary). That said, a quick search for "php excel" on the 'net gave me lots of options. I highly recommend doing the same. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.