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?
|