| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access Queries not seen in Excel
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access Queries into Excel | Excel Worksheet Functions | |||
| cpu load excel with access queries | Excel Discussion (Misc queries) | |||
| Queries from Excel 2003 to Access | Excel Discussion (Misc queries) | |||
| Excel Queries using Access data | Excel Discussion (Misc queries) | |||
| Using Excel Worksheets like Access Queries | Links and Linking in Excel | |||
Linear Mode
