View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excel Access Imports

hi
not sure. i'm assuming at this point that your are trying to import a query
from the same database. what database? Access?
If you are gettng headers, you should be connected. Are there parameters in
the query that might be restricting the data? if so, you need to remove them
and place any parameters(criteria) on the excel side. can you get data from
the query when you run the query in the database?

post back with more infor about the query?
Regards
FSt1



"Tom J" wrote:

Anyone,
While in Excell I am attempting to "Get External Data" from an Access
database. When I follow through and select the table I wish from that data
base everything imports fine. All records and fields are imported. However,
when I try to import a query only the field headings come across with no
recors data. I have checked design view and the records are not listed. What
am I missing here?
Thanks
Tom J