External query - No columns

[EvertDeJongh]

Hi,
I am trying to import an Access query via External Query. I see the
query name but when i click on the + (plus) sign it does not show any
columns. I can see another querys columns and cannot see the
difference between this query and the one that does not work.
I changed the query to create a table and this table i can import.
I am using Access & Excel 2000.
Thanx
Evert

 

[dan dungan]

Hi Evert,

I'm trying to replication your situation. I don't understand how
import an Access query using external query.

Please describe the steps you take to import an Access query.

Thanks,

Dan

 

[EvertDeJongh]

HiEvert,

I'm trying to replication your situation. I don't understand how
import anAccessquery using external query.

Please describe the steps you take to import anAccessquery.

Thanks,

Dan

Hi,

Data
- Get External Data
- New Database Query

 

[scott]

I know you mentioned you did not see how this query might be different
than others. Did you look at the SQL statement for each?
They are in the same database? so it is not an ODBC issue.
Is the database remote or local?
Do you have the most recent Jet updates available for your version of
Access?

I have had the same issue at times and never completely resolved this.
I am curious too.
Hope someone responds
Scott