Importing Excel Spreadsheet into Access

D

Django

I am trying to import an excel spreadsheet with dropdown box into excel.
Somehow when I try to import it, it does not look the same as the excel
spreadsheet, especially after trying to create a form in Access. Can anyone
tell me how a drop box is imported from Excel to Access? I am using Office
2007. Appreciate any assistance that you can provide.
 
K

Klatuu

Only the cell values are imported from Excel into Access, not any formatting.
You will need to create the combo box on the form yourself.
 
Top