Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I recently created a new Access database and am setting up several Excel
spreadsheets to display query results. I created Query A, then opened a new Excel spreadsheet, then imported the data from Query A. I adjusted the formatting to my liking, and now I just hit "Refresh Data" when I open it and everything's fine. A similar experience with Query B. However, today, I created Query C, and the "Select Table" dialog (from Import External Data) doesn't show it. I thought at first Excel might be looking at an old version of the database or something, so I created Query D, a simple select query that displayed the ID# of each record, and Query E, an exact copy of Query C. Now, I can see Queries A, B, and D, but not C or E. So, I assume there's some property of Query C that's preventing Excel from recognizing it. What would prevent Excel from being able to see/import an Access query? By the way, I can export Query C into an Excel file from Access, but I'd like to be able to update from Excel rather than having to re-export and fix the formatting every time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
excel - access query - date range | Excel Discussion (Misc queries) | |||
Problems Importing from Access | Excel Discussion (Misc queries) | |||
Importing a table from Access query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |