B
BorisS
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.
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.