Importing from Excel to a droplist field

[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?

 

[pietlinden]

I am trying to do is append about 75 new records from an excel
spreadsheet.

What if you use TransferSpreadsheet with a range (if applicable) and a
saved import specification?