Duplicating record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm currently using a table that consists of about 300 columns and is filled
with records. Now, how can I duplicate a specific record (identified by a
automatically growing unique ! integer)? I've tried INSERT INTO SELECT
statements, but unfortunately, as the table does not accept duplicates for a
good reason, the request is rejected/has no effect. How can I duplicate a
record in a table and automatically assign a new autovalue to a specific
field?

Thanks for any help,

Peter
 
You can't possibly be doing this in Access, as there's a 255 field limit for
tables.

When using the INSERT INTO ... SELECT statement, you need to explicitly list
all of the fields, except for the Autonumber field:

INSERT INTO MyTable (Field1, Field2, Field3, ...)
SELECT Field1, Field2, Field3
FROM MyTable
WHERE ID = 1234
 
Back
Top