Excel to MySQL

[JoyDivision]

I need to produce a bespoke database system for my parents as my dads currently using Excel and it a problem. I was thinking of producing a web based database system.

The problem is there is currently 4000 records stored on this spreadsheet so I need an automatic way of converting the records into a MySQL database.

Has anybody got any ideas?

[Rob Holmes]

If your webhost has phpmyadmin installed (most do) then you can import the data base as a csv file.

Have a look here: http://www.phpmyadmin.net

Rob