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

Access Subscript out of range when importing into access 2010 from excel 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Error Importing Excel Spreadsheet into Access 1
Importing Excel spreadsheet into Acces 1
Importing Excel into Access 1
Importing excel spreadsheet into multiple Access Tables. 4
Import data from Access to Excel containing VB code 3
Import Excel Spreadsheet 1

Top