export - operationis not supported

D

Dabbler

I have a query setup as an SQL Pass-Through Query using a stored procedure.
"EXECUTE RidesTakenByMonth_October"

The query runs fine and provides a result set but when I try and export it
to Excel 97-2002 I get the following error:
"Operation is not supported for this type of object"

Can anyone suggest a workaround, I need this data in Excel format to provide
to my client.

Thanks much!
 
B

Brian

Try this: create a second query using your pass-through query as its source
(i.e. just "Select * from [NameOfPassThroughQuery]"). Save it, and see if you
can export from this one.
 
Top