Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-12 : 07:24:26
|
| Venkatesh writes "In MS-Access table a coulmn is specified as Auto number property.I want to migrate this table into SQL Server.We can create a new column that has identity property in SQL Server 2000, which simulate autonumber property of MS-Access.My access table contains 700 records and I need to set the column (ListID) as Auto number. i.e., I m going to modify this coulmn with identity property.But I cant set the identity property for the existing column.Can u pls send me the sql query that modify the existing column(ListId) with Identity property.RegardsVenkatesh" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-12 : 07:39:28
|
| You should do it in Enterprise Manager and see the Script1 Drop the old column2 Create new column with identity3 Name it to ListIdMadhivananFailing to plan is Planning to fail |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-12 : 12:39:50
|
| Migrate to SQL server ?either one of two methodsuse upsize wizard or DTS import/export UTILITY |
|
|
|
|
|
|
Migration of MS-Access table into SQL Server 2000