Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
viewing newly created access queries in excel via msquery
This is hopefully something simple that I've overlooked. I'm trying to
update an existing Excel pivot table using the refresh command. The table is refreshed from an access database containing many (30+) queries. I connect to Access via ODBC, using MSQuery to display a list of queries from the database. I have just created a new query in the Access database. The problem is that MSQuery lists my existing (old) queries but refuses to display the newly created one that I need to use to update Excel. I've tried various restarts etc. but it still does not appear. Any ideas on how to make MSQuery display the new query so that I can actually use it would be greatly appreciated. Thanks in advance for your time and effort. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
access query reports to excel formatting help | New Users to Excel | |||
Security for Viewing MS Access Databases From Excel Datasource | Excel Discussion (Misc queries) | |||
Finding and killing all Access queries in an Excel spreadsheet | Links and Linking in Excel | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |