Wednesday, June 27, 2012 9:45 PM
I've imported some excel sheets into new tables. These sheets were from another existing Access database, and already contained an ID field, which I selected as the primary key when importing. I want this field to be an autonumber, but I can't change the type. For that matter, I can't even seem to add a new Autonumber field to this table. How do I do this?
I need these tables to have an autonumber. I looked at using the standard work around, using DMax, but aggregate functions aren't allowed with web tables.
Friday, June 29, 2012 9:35 AMModerator
Thanks for posting in the MSDN Forum.
I'll involve some experts who are familiar with your issue, this may take some time. Much appreciate for your patient and understanding.
MSDN Community Support | Feedback to us
Friday, June 29, 2012 6:36 PMAnswerer
If you import the tables directly from the Access client database instead of going through Excel, the autonumber should be retained. If you no longer have the client database, the structure of the table will have to be recreated and then the data imported.
I hope this helps!
Sharon M, Microsoft Online Community Support
Friday, June 29, 2012 6:50 PM
I resolved the issue by rebuilding the tables. I created new tables, with autonumber fields, then added new fields manually to match the existing tables I had imported. From there, I just copied and pasted the data over.
I had to import through Excel because we had lost connection to the Sharepoint server, so the tables would not export into the new Access database.
- Marked As Answer by Leo_GaoModerator Monday, August 13, 2012 9:14 AM