Lotus 123 to sql

[flashingcurser]

First I will admit I know absolutely nothing about databases. My morinig boss (who is 74 god bless his sole) created a 123 spreadsheet for restaurants--it has literaly hundreds of recepies and at least a hundred food costs--out puts recepie costs--recepie prices and portion sizes (along with dozons of other things). This is a very large spread sheet.

He would like to set this up as a server for each resaurant that he does consulting for. He would like remote/local network input of food costs and remote/local network queries of recepie prices/costs.

First, this is perfect application for a sql type database right?

Second is there a nice noob frienly linux gui (or walk-me-by-the-hand tutorial) I can use to learn on?

Third is there a way to convert lotus spreadsheets into sql?

Any thoughts would help. I'm pretty sure I can set up the network/server without much trouble--the database stuff is completly uncharted waters.

Thanks

[flashingcurser]

Bump..... Anyone?

Have any of you used a mysql gui app--any recomendations?

[crouse]

If ALL the fields are the same on ALL the pages..... you can save as CSV and create a flat text database file that way. You can even get the perl scripts needed to use it from flattext.com (not free though) ... and also get mysql scripts for using the same database if you prefer. If it's small , the flat text style database will work fine.

[crouse]

As for manipulating databases with linux....


http://www.rekallrevealed.org/index.php
http://ksql.sourceforge.net/
http://www.fabforce.net/dbdesigner4/
http://gmyclient.sourceforge.net/
http://www.knoda.org/
http://wmf.dyndns.org/ (myphpadmin)
http://ems-hitech.com/mymanager/ (not free)

[flashingcurser]

Thanks, I'll check out your links