New Database query

I'm not sure if this is an Excel 97 problem or an Access 2000 issue, but I'll try here first. I am trying to pull a database query into an Excel 97 spreadsheet. I go to Data, Import External Data, New Database Query . . . I click the MS Access Database, Select the database, Pick my query and the fields (all), no filter or sort, and when I click to return data to Excel, the cursor changes to an hourglass for approximately 2 seconds, then nothing happens. The query I am pulling from is an append query run from a macro. I have multiple queries in this macro. When I run each of the individual queries by themselves, I am able to pull the data into the spreadsheet without any issues. The data from the macro is well under excel limitations, there are only 96 items. Does anyone have an idea as to what may be causing the problem?
Thanks in advance.
Paul

Originally Posted by PaulSilk

I'm not sure if this is an Excel 97 problem or an Access 2000 issue, but I'll try here first. I am trying to pull a database query into an Excel 97 spreadsheet. I go to Data, Import External Data, New Database Query . . . I click the MS Access Database, Select the database, Pick my query and the fields (all), no filter or sort, and when I click to return data to Excel, the cursor changes to an hourglass for approximately 2 seconds, then nothing happens. The query I am pulling from is an append query run from a macro. I have multiple queries in this macro. When I run each of the individual queries by themselves, I am able to pull the data into the spreadsheet without any issues. The data from the macro is well under excel limitations, there are only 96 items. Does anyone have an idea as to what may be causing the problem?
Thanks in advance.
Paul

I need to make an amendment to this post. I did mistate something and maybe this will explain it better. In Access, I have an append query but from that append query there is a crosstab query which is the actual data I am pulling in. Here is the actual scenario. I have 10 queries of employee titles. I run these to append to a table. From that table I run a crosstab query to have the AD groups these users are assigned to show across the top and "X" in the columns under then if they belong in a specific group. When I run each of the job title queries individually, they import successfully into Excel. But when I run a macro with all 10 job titles, this will not import into Excel. Hopefully that will explain it better. Is there a limitation in regards to importting crosstab query data into excel?

Thank you!