Mike Diehl wrote:
> 1. Create a table for each spreadsheet, using column headings as field names.
> Every field would be a char/varchar. We might have a table to track which
> client owns which table. This could amount to 10's of tables being added to
> the db.
Give each client their own schema. Set permissions on the whole schema.
You should be fine with a few dozen or a few hundred tables. You can
also dump/restore a whole schema then.
--
Richard Huxton
Archonet Ltd