Linking Excel and Access

  • Thread starter Thread starter Eliezer
  • Start date Start date
E

Eliezer

Hello... I'm trying to set up an excel sheet in such a
manner that if a certain record exists (based upon it's
primary keys) in an Access database, the cell will return
X, and if not, it will return Y. Is there a method to hook
up access and excel like this? I tried using PivotTables
(based upon Excel help), but I'm not very experienced with
them and they did not produce the desired outcome. Thanks -
Eliezer
 
For something this straightforward, take a look at SQL.REQUEST in the
Excel help files.
 
Back
Top