We help IT Professionals succeed at work.
Get Started

We want MS Access to use a combo box to pull names from an Excel spreadsheet column

359 Views
Last Modified: 2012-05-12
We have four MS Access databases that are used almost on a daily basis. Each database contains records that are input and maintained by members of the staff.  The person who updated the items are listed in a field on each database.  The names of staff members change frequently because of people leaving the job or people being hired.  

There is an official excel spreadsheet list that is kept on a shared drive and is updated frequently by the administrative staff.

I have decided that I want all of our databases to pull the staff members' names from the excel list and not depend on local lists created for each table in the databases.  I would like to have pull downs in each db on the field that holds the names and allow the users to select from that current list since it is always up-to-date.

My problem is that Access will not allow me to use the Excel spreadsheet to supply the names because it wants to use a list from an Access table.

Is it possible to create an Access combo box which will pull the names from the Excel spreadsheet column? We are using Access version 2007 in Windows.
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
Unlock 1 Answer and 13 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE