Essentially my issue is that I've got a field linked to another table, but when importing data from excel for that field, I have to use the primary key attached to the data. As in say I have two fields, one AutoNumber (the primary key) and one with text. If I try to link to the text field, access actually thinks I'm linking to the primary key field and just displaying the text. So when I import a spreadsheet using text for that field, I get a type mismatch error. Is there any way around this?
I can't just change the primary key to the text field, as there is a possibility (however slight) that two records may have the same text, and I want to avoid having to figure out what the primary key is for each record as there are thousands to go through
I can't just change the primary key to the text field, as there is a possibility (however slight) that two records may have the same text, and I want to avoid having to figure out what the primary key is for each record as there are thousands to go through