Excel - Get Extenal Data question

  • Thread starter Thread starter Correy
  • Start date Start date
C

Correy

Hello,

I was wondering when using the "Get External Data" feature in Excel from an
Access Database.....is there a way to only allow certain tables/fields to be
selected?

What I'm finding is when setting up a new or editing an existing query using
the Get external data feature it shows all the tables/fields.

I would like to setup a query where the users can't get access to the data
in the other tables/fields I don't want them to.

Any suggestions would be greatly appreciated.
Thanks, Correy
 
Back
Top