I'm trying to create a drown down list in excel that is link to a query in
access. Right now i create a list in the workbook I'm working on, then use a
validation option in the Data menu to create the drop down.

I want to use an Acccess file as a central location where people can add new
items to the drop down list. I don't know if this is possible, but if anyone
knows how to do this, please help!!!!!!!!!!!

In Excel, you could use DataGet External DataNew Database Query, and
pull the data from the query onto a worksheet.

When you import the data, a name is automatically created, e.g. Query
from MS Access Database. Use that name as the source for the data
validation list, and it will automatically adjust.

David T wrote:
I'm trying to create a drown down list in excel that is link to a query in
access. Right now i create a list in the workbook I'm working on, then use a
validation option in the Data menu to create the drop down.

I want to use an Acccess file as a central location where people can add new
items to the drop down list. I don't know if this is possible, but if anyone
knows how to do this, please help!!!!!!!!!!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html