I have an access database. I need to import date from another source which includes a id field. This id field in the access database is set to be an autonumber. I can not seem to find a way to import in such a way that I can set this field while importing, and have it autonumber afterwards.
I only need to do this once, at the very start of using the database.
I have tried setting the field to numeric and then after the import change it to autonumber but that won't work
I'm used to working with SQL Server, there you can play with the 'identity insert' option to do this.