How to make a Web Query?

[Matrix0319]

Hello Guys,

Hope you can help me on how to make a web query? I am creating a webpage for our company and they wanted to have a page that will show "where to buy products?" I have a database written in an Excel format given 4 fields: Company Name, Tel Nos., City, and Province. What I wanted to do is to have 2 drop-down menus for city and province and once they selected from the list then after clicking the GO, it will show what matches in my Excel file. For example, they selected Seattle in City menu and Washington in Province menu then after clicking menu it will show what are the name of the stores and their telephone numbers that matches the criteria.

Please help me! I am a newbie in webpage so if you can help me direct to link where I can copy a script then I'll just modify something that will be much better.

Thanks a lot.

email me at delacruzjeff@yahoo.ca

Jeff

 

[jemminger]

hi Jeff -

let me steer you away from trying to use Excel as a database for your web app. first reason: it's not easily accomplished, secondly: Excel is not designed for this.

Use MS Access at the very least, or some true web-ready database like MSSQL, mySQL, Oracle, etc...

Use a server-side language like ASP or PHP to write your site. These work well with Access/MSSQL/mySQL.

You can find web hosts that offer ASP/Access or PHP/mySQL for $5/mo. and higher...I've heard good things about readyhosting.com

=========================================================
if (!succeed) try();
-jeff