Make Table / Making a ID Field

[Shadez]

Is there a way to designate a the ID field through the sql statement as you create the table? I am currently working on an import utility I have included the sql statement from a small table.

Any help would be great.

SELECT dbo_States.StateID, dbo_States.StateAbbr, dbo_States.StateName INTO States
FROM dbo_States;

 

[downwitchyobadself]

You can't do it through the SQL, but you can add the field just after, and you could do it programmatically, using DAO it's get the TableDef, then the CreateField method (you can pull both of those up in VBA Help).

The other solution, if your SQL is staying pretty much the same, is to define the table as you want it, then run first a delete, then an append query against the table. Allows not only for an AutoNumber field, but also for things like primary-key control. Personally I almost never use make-table queries...

 

[p27br]

You can add an index field with an sql statement.
docmd.runsql "alter table add column field counter constraint primary key"