Importing Excel Spreadsheet into Access

  • Thread starter Thread starter Django
  • Start date Start date
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.
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Excel Data Transfer Issue (strange situation) 1
Importing Excel spreadsheet into Acces 1
Import Excel Spreadsheet 1
Importing excel spreadsheet into multiple Access Tables. 4
search key not found in any record 4
Import data from Access to Excel containing VB code 3

Back
Top