Import text data into existing linked field?
Posted on 2007-11-29
I'm trying to import data (using the wizard) from a text file into a table that has a number of linked fields to other tables.
So, in particular, I'm trying to get one field from the text file that's a list of names. The destination field is a link to another table, so it's data type is actually "number" (although the field it links to is a text field). When I try to import, I get an "Invalid Argument" error.
Maybe I have to import each field from the text file separately not into the linked fields, but into the other tables that are linked to? Actually, now that I think about it, this wouldn't work, as the relationships of the links are "many to one".
Can this be done, or am I SOL? Need more info?