From Acces to SQL -- auto numbers

[newby]

Can you add info using the insert SQL command and make it work if the first column is an auto number ?

[Island1]

What you propose sounds fine ... If the table contains an AutoNumber field, do not include this field in the SQL INSERT command (the value of this field will be taken care of automatically).

Background and Added Info:

An AutoNumber field (also refered to as a Counter field) is a data type that automatically creates and stores a number for each item added to a table. If you append records to a table with an AutoNumber field and you do not want the AutoNumbered field to be renumbered, you must include the AutoNumber field number in the query. If you do not include the AutoNumber field, the appended items will be assigned a new AutoNumber field value.

HTH. Good Luck!

Bill

[newby]

Bill Thanks!! I'll let you know what happens.

[Island1]

Posting your evolving experiences is appreciated by the community in general.

Best of luck!

Bill