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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Using Office Forms and dynamically updating the excel backend 0
Excel Data Transfer Issue (strange situation) 1
Importing Excel spreadsheet into Acces 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Word macro that can call cells out of Excel for a find and replace 0
Import to many to many table 7
Access Count query 1

Top