Importing Data from Excel 03

[Elizabeth]

I am trying to import data from Excel into an existing Access table. I have
two columns in the Access table that offer drop down enteries from a lookup
list. It is set up this way so that when I enter information manually, I
can choose from a list of companies to associate with an entry. However,
when I import the table from Excel into Access, it leaves those columns blank
which Access treats as Lookup columns. Is there any way to get Access to
take the entry from the Excel column (the entries are valid and exist in the
list that you can select from)?

 

[Chris O'C via AccessMonster.com]

Lookup fields cause more problems than they solve. You can't import the
spreadsheet data into that table because it only holds the foreign keys of
those rows in another table for each lookup field.

Redesign the table and use a combo box on a form to manually enter data, not
lookup fields in the table.

Chris