LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing result from Access query to Excel but the result only c. Edwin Excel Discussion (Misc queries) 0 March 16th 06 01:36 AM
excel - access query - date range mxp Excel Discussion (Misc queries) 1 January 31st 06 03:44 PM
Problems Importing from Access davey Excel Discussion (Misc queries) 1 July 8th 05 05:47 PM
Importing a table from Access query Trish Excel Discussion (Misc queries) 1 May 12th 05 08:44 AM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"