My database is made up of 6 tables imported from Excel, there are X records each with a primary key called "Unique ID" which was created in excel and imported into access.
When I add a new record I'd like to auto increment this value, though access tells me it's impossible to change the field type of imported data.
Can anyone think of another way of acheiving this, without adding in an extra field with auto increment -- or is that simply the only way?
Thanks,
Jordan
When I add a new record I'd like to auto increment this value, though access tells me it's impossible to change the field type of imported data.
Can anyone think of another way of acheiving this, without adding in an extra field with auto increment -- or is that simply the only way?
Thanks,
Jordan