I'm still in the planning/construction stage of my first website aimed at a specific audience. I have very solid html/xhtml and css knowledge and am now developing my PHP and MySQL skills.
My goal is for people to enter a postcode or suburb name in order to access all appropriate businesses in their area.
I have built an excel spreadsheet of all the businesses that are relevant to the proposed site, but I need to transfer the several thousand listed businesses into a MySQL database without entering them one at a time. Is there an efficient way to transport my excel file into MySQL or is there a better way to use my excel spreadsheet for web searching?
My goal is for people to enter a postcode or suburb name in order to access all appropriate businesses in their area.
I have built an excel spreadsheet of all the businesses that are relevant to the proposed site, but I need to transfer the several thousand listed businesses into a MySQL database without entering them one at a time. Is there an efficient way to transport my excel file into MySQL or is there a better way to use my excel spreadsheet for web searching?