Importing excel combo box into access

[USMCFROSTY]

I'm using 2010 and need to import my excel sheet1 into access. I have a combo box (Active X with a source on sheet2). When the combo box is populated in excel its fine but when i import into access i get blanks.. Do i need to reference the source list and if so, whats the best way to do this?

 

[HGMonaro]

I'm guessing you need to link ("cell link" field in format control) your combobox to a cell in sheet1. If you have one of these per row then cell validation using a list (named range on sheet 2) might work better (I tried this and it imports fine)