Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identity Specification
I have a PK column defined with.
Identity Specification = Yes Is Identity = Yes Identity Increment = 1 Seed = 1 The table has no data. Is it possible to import from another table with unique numbers into this column? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identity Specification
it sounds like you're in the wromg news group. But yes.
First switch off the column's identity, leaving it just as a BIGINT the you INSERT INTO thistable (tableid) values select distinct (col) from tablesource then turn on the identity again "tcb" wrote: I have a PK column defined with. Identity Specification = Yes Is Identity = Yes Identity Increment = 1 Seed = 1 The table has no data. Is it possible to import from another table with unique numbers into this column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel DCOM Identity | Excel Programming | |||
Identity on Database Fields | Excel Programming | |||
User identity | Excel Programming | |||
vlookup file specification | Excel Worksheet Functions | |||
Help with .Add specification | Excel Programming |