![]() |
Problems importing from an Access query
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. |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com