Linking to Access table

M

Mark

Hi. Similar to a poster earlier today, I'm creating a Pivot Table based on
data in an Access database. When I link to my database, in the Select Table
dialog box I see my tables and one query, but not the other query which is
the one I want to link to. What would cause one query to be available but
not the other? The unavailable one is based on the other one, though I
wouldn't think that would make a difference. Any ideas? BTW, this happens
in both Excel/Access 2002 and Excel/Access 2007. Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top