Thread: linking table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?