For a database of components (instruments, valves, etc) in an industrial installation, I need to get data from an MS Excel table filled with information by engineers. Linking the table works fine, but I haven't been able to establish a primary key. Is it possible to tag a field with a primary key? If not (what seems to be the case), how do I find my information in the linked Access table?
Thanks in advance.