hi all--

i am looking for a way to duplicate a table.

i do not mean to create another instance, as one may have to do in
defining some relationships, but to create an actual duplicate 'copy'
of an existing table.

i am inquiring because i have a table with a few hundred fields (the
rationale for this is that the table should not be more normalized as
they are all protein attributes, and other functional reasons)

i wish to create a copy of this table.


my end goal is to accomplish something like this:
1) have an existing table that serves as the data repository
2) import excel spreadsheets into the second 'copy' table
3) compare each field value for each record in the data repository to
the 'copy table'
4) identify any non-matching data
5) allow the user to modify the copy table's non-matching data/and or
choose to overwrite the data repository data

that is the functionality that i am looking for. i can do all of that,
with the exception of replicating the data repository table (with all
the value lists associated etc).

I am also open to other solutions that would allow a user to import
data into the data repository but generate a custom dialog whenever a
field value for a given record on the import file might not match the
field value of a given record in the data repository if the id of the
data repository record and the import file match (i.e. that the record
being imported is not a 'new' record)

i hope this question is not too muddled and would be happy to provide
any clarification and appreciate all thoughts.

best,
sg

You could simply save a copy using "save a copy as...". If I'm missing
something, you could create a blank copy with a new name, then import directly
from the original into the new one or export from the original and import the
resulting file into the blank copy.

Kent

MaximalVariance wrote:

Would 'file', 'save a copy as' work? Then you can save it with or without
records.


"MaximalVariance" <StephenTGallagher (AT) gmail (DOT) com> wrote

I would agree with the duplicate file suggestion, unless you can upgrade to a current version (8+), which allows simply copying and pasting a table, complete with field definitions.

Matt

On 12/07/2006 18:34:57 Kent <kent.news.account (AT) gmail (DOT) com> wrote: