Creating duplicate data

[Christian Wirth]

Hi,

I would like to duplicate distinct rows of data. Something like: I've
got one customer stored and to want to have a copy of his data, with
only the primary key being different. Only one row of data from one
table will be affected by this operation (and the second one I insert,
of course).

I thought about something like "insert into customer (select * from
customer where .....)" or "insert into customer as select ..." but
that's not working.

A solution would be of course to read all the data I need and write it
back to access with a different primary kes (I'm using Visual C++ for
that). I just guess it can be done easier with a few SQL-Statements.

Thanks for any ideas,
Christian Wirth

[Pieter Linden]

Select everything but the primary key of the table and reinsert it...
ugly, but it should work.