For experts in DP: I need your guide to set up search option from Miscrosoft Excel file details. I have about 10 columns and 10,000 Rows of excel sheet with data. I want to offer search option from website using this excel sheet. Please guide me on conversion to preferred database, how to create query and drop box or search box. Is there any script that does this automatically? Please help. Kudos will be added. Thank you
There is an excellent MySQL GUI called MySQL Front. It lets you import any excel document into a MySQL database. You can then create a simple script in PHP to access the database and search it.