K
Ken
I have a table in Access 2007 in which a particular field is filled in from a
droplist. Whoever enters data into the table selects one of a possible four
choices.
In case you're curious, it is to select which branch office the relevant
record refers to, of four possibilities.
However, what I am trying to do is append about 75 new records from an excel
spreadsheet. The trouble is that I can't seem to specify any value in excel
that access will use to automatically select an option in the field.
I tried it this way:
I exported the table first, to see what value access would assign the field
in the exported table. Then I copied that value into the new excel
spreadsheet and imported that sheet, hoping that access would recognize those
values. It did not.
The next thing I tried was to use a numeric value, such as 1, 2, 3, or 4,
since this is how a similar operation works when refering to data from one
table to another within access. That resulted in an "unparcable record"
error.
I'm lost now. What value do I need to put in the excel cells in order for
access to import that field correctly?
droplist. Whoever enters data into the table selects one of a possible four
choices.
In case you're curious, it is to select which branch office the relevant
record refers to, of four possibilities.
However, what I am trying to do is append about 75 new records from an excel
spreadsheet. The trouble is that I can't seem to specify any value in excel
that access will use to automatically select an option in the field.
I tried it this way:
I exported the table first, to see what value access would assign the field
in the exported table. Then I copied that value into the new excel
spreadsheet and imported that sheet, hoping that access would recognize those
values. It did not.
The next thing I tried was to use a numeric value, such as 1, 2, 3, or 4,
since this is how a similar operation works when refering to data from one
table to another within access. That resulted in an "unparcable record"
error.
I'm lost now. What value do I need to put in the excel cells in order for
access to import that field correctly?