linking table
 

I know how to link a table from access to excel, but was wondering,

Is there a way to link 1 column from an access table to 1 cell in an excel
spreadsheet and then have the column be a drop down of all the values from
the access table?

linking table
 

If you mean using Data = Validation, then not directly. You could set up a
querytable to bring the data into excel, then link the data to you data
validation dropdown through a defined name.

--
Regards,
Tom Ogilvy

"Jamesmor" wrote in message
...
I know how to link a table from access to excel, but was wondering,

Is there a way to link 1 column from an access table to 1 cell in an excel
spreadsheet and then have the column be a drop down of all the values from
the access table?