In trying to move some test data from production to test I tried to use "append from production". I am using an autoincrement field for id and it doesn't like the "append from" saying it is read only.

I know I can scan the table and drop the values each field or can use SQL "insert into test(field1,field2) select field1,field2 from production) " but both require a listing of fields. Since this is a table with many many fields, is there a simplier way to move the data between tables with auto increment fields.


Thanks
Gaylen