Creating Auto-Identity with SELECT INTO MS Access

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Creating Auto-Identity with SELECT INTO MS Access

Author

Topic

maflip
Starting Member

3 Posts

Posted - 2006-10-24 : 12:58:51

Can someone tell me how to implement a "select into" statement in MS Access that has an auto-number Identity column? Thanks.

Mike

X002548
Not Just a Number

15586 Posts

Posted - 2006-10-24 : 13:08:21

Well you probaly want to post here

http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3

or here

http://www.dbforums.com/forumdisplay.php?f=84

SELECT Collist, INTO test
FROM TABLE;

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-24 : 13:19:11

Cross post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73984

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources