View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default external validation

Two questions:

1) can/how does Excel do validation from an Access DB
2) if it can, is there a way to do over ODBC connection to a DB not on the
computer

One thought for my challenge was to get a PTable to go to the Access DB by
simple query, but the resulting table is massive, and the whole objective is
to keep a light worksheet, which ensures some particular data integrity.

Thx.
--
Boris