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
