Hi everyone, I'm developing a website that basically has to access a database (created in excel) that will pick information from a 2 dimensional database given user input with a range of options (could be a drop down menu). Example Input 1= Sandwich style: BLT, Veggie, Cheese, Gourmet, etc Input 2= Type of bread: Anpan, Arepa, Bagel, Baguette, etc User selects BLT and Bagel. Output: 2,35 Dollars (Price of the sandwich) I want to make this into a very simple website that will give the user access to the information (the price) by selecting the available options, let me know if you have any recommendations to do this! Thanks a lot!!!
most people would not use excel for db needs. depending on what coding technology you use php, c# you can connect to the excel. which language you are using?
Excel is a bit of a strange one for a web site. From what you describe, adding a proper DB (MS SQL, MySQL) may be a bit of overkill, and your decision to use Excel might not be that bad after all given that an XLS file is just a text file. However.....you might be better off using an XML file to store the small amount of data as that is more widely recognized format and probably easier to work with from a developers perspective (and more portable).