Access Queries not seen in Excel

R

RGBrighton

Hi,
I have a queriy in Access that I want to import into Excel (2007).
I go to "Get External Data" - "From Access" and select the Access database.
Several tables and queries are shown but some are not (naturally the one I
want is not shown!)

I had the same problem importing the same query into Word and resolved it by
setting the "Confirm File Format Conversion on Open" option in the Advanced
Options. (Then choosing DDE when opening).

Is there a similar way I can get Excel to see this query?

Thanks
Richard
 

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

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Menu Macro Not Executing - Need Help 1
Autonumber field in Excel that behaves the same as Access 0
Word 2013 merge Excel, DDE conncetion path problem 0
Embed the same Excel multiple times 0
Some mail merge fields not pulling into document 2
Not all Access queries can be imported 1
Table Security in Access 2013 1

Top