LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Getting query data from Access

I figured it out myself. It appears that if the query has parameters, then
it is excluded from the list. Would have thought that it would have done the
request for the parameters but so be it. Hope this helps someone else. BUD

"Bud Cookson" wrote:

I am attempting to pull external data from Access 2007 into Excel 2007. I am
using the normal "Get External Data" "From Access". I select the
appropriate Access database and go through the configuration to the point of
selecting the query/table. My question is why do I NOT see all of the
queries? I am only seeing some of them. The one that I want is not visible.
I only want to view the data in Excel. Any thoughts would be appreciated.
BUD

 
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
Import Data from Access query Andy Excel Discussion (Misc queries) 8 April 23rd 09 09:15 AM
Get External Data from Access Parameter Query NewUser Excel Discussion (Misc queries) 0 December 1st 07 03:24 AM
Excel Data Query from Access Luke Bailey Excel Discussion (Misc queries) 0 February 13th 07 11:24 PM
import data from an Access parameter query PluckyMo Excel Discussion (Misc queries) 2 April 12th 06 04:42 AM
Data extract from access query TrevorM Excel Discussion (Misc queries) 4 September 23rd 05 09:29 AM


All times are GMT +1. The time now is 12:05 AM.

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"