drop down data into Access

[Guest]

I have an excel template that uses drop downs. I want to import that data to
Access, but when I import the table, the drop down values are blank. Is
there a solution?

 

[Debra Dalgleish]

If the dropdowns are combo boxes, you could link them to cells in the
table. Then, when you import the table, it will include the data that
was selected in the combo boxes.

Or, instead of combo boxes, you could use data validation lists. There
are instructions here:

http://www.contextures.com/xlDataVal01.html