Query Access 97 from Excel 97

  • Thread starter Thread starter Hawk
  • Start date Start date
H

Hawk

Not sure whether to post this under Excel or Access (I
will try both)...

I am trying to query an Access 97 database from Excel 97
by selecting:

Data -> Get External Data -> Create New Query

From the Query Wizard, I am able to see the tables within
the database, but not the fields. I am assuming it must
be a permissions problem. I have given the Users group
Open/Run permissions to the database, and I have given the
same group Read Data & Read Design to the tables. Any
ideas would be greatly appreciated...
 
I am no expert but when I try a query, in the way you
explained, it works without any problems.

You said the tables are visible, did you expand the table
by clicking on the + symbol?

Charlie
 
Back
Top