Convert from Excel to Database for website

[SingHouston]

I would like guidance on what is involved in converting data that I currently keep updated in excel to mysql database. I would like to be able to let the user be able to query the data and see the results on that web site. You can see the current website at www.singhouston.com.

I'm new to this , thanks for any help in advance!!!

HoustonSinger

[Roger_Ramjet]

Save the Excel spreadsheet data as a csv file File->Save as->CSV (comma-delimited txt). You can then use a variety of methods to load the data into mysql tables.

[SingHouston]

Rodger, What I'm trying to figure out is 1) is there a program that I can use to get the data out of the database and onto the web site that will let the user query(limited to canned queries) the data.

[Davy]

Roger's method is to fully import the Excel data into a database. Are you looking for a method to 'grab' data on the fly? If so, there is a few functions that can be used in php to 'grab' the data using queries and arrays.

Anyways, that's only to get the info onto the MySQL database. You must thenc ode a way of the user inputting thier 'search criteria'. Then a page must be coded to look for these search criteria, fetch it from database then format it for display.

There isn't a program to do this as such. PHPMyAdmin, PHP and MySQL to name a few 😛