You have to append to a temp table or cursor, populate the id column there with the values you want for the master table, then append from the temp to the master table.
Or, write code to append a record at a time, update the id, then do the next record.
>I'm copying table contents from one file to another and ran into an error while copying a table with an autonumber field. It says the field is read-only (which makes sense, I guess), and won't copy the records using an append from statement. Is there a quick/standard way to get around this? I know I could do a file copy, but was hoping to just pull records as needed from the other table.
>
>As always, thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer