No, you can't rely on the Identity field keeping the same number as
the autonumber field.


On Fri, 29 Aug 2003 12:25:28 +0100, "For example John Smith"
<someone@microsoft.com> wrote:
>I'm doing a data transfer from Access to SQL Server, I wish to keep the
>identity column (autonumber) values as all the data is already related. I
>tried the first table append query including the identity column, it worked.
>Was this fluke? Will it always work? I was under the impression that I would
>have to issue a "set identity_insert on" before doing this. The SQL database
>will have absolutely no data before the transfer routines are run.


--
You're Not Losing More Hair, You're Gaining More Scalp.