transliminal
New member
- Local time
- Today, 01:40
- Joined
- Sep 27, 2019
- Messages
- 4
Hi there,
I have some data to import from an excel file in which the primary key is in GUID ('Replication ID') format.
I want to convert the excel sheet into a table in Access that will keep generating unique GUIDs for future records.
I'm having trouble, because it seems an Autogenerate field cannot accept copy-pasted data, even if they're both in GUID/Replication ID format.
Any solutions?
Cheers,
I have some data to import from an excel file in which the primary key is in GUID ('Replication ID') format.
I want to convert the excel sheet into a table in Access that will keep generating unique GUIDs for future records.
I'm having trouble, because it seems an Autogenerate field cannot accept copy-pasted data, even if they're both in GUID/Replication ID format.
Any solutions?
Cheers,