Retrieving SQL data into Excel - Part II
 

Hi,

I have rather complex SQL Server query using CASE function, table joins,
etc. that I was able to execute in MS Query (MSQRY32.exe). However, when I
try to export or open the saved query file (.dqy) into MS Excel, it reports
an error (Microsoft Excel could not open or read this query file. Either the
file has been damaged or the file format is not valid).

Has anyone seen this before? My user isn't tech savvy and would just like to
double-click this query so that it automatically populates his Excel
spreadsheet with the result of the saved query.

I have tried using this approach without the CASE function on another
simpler query and was able to retieve the data in Excel successfully. So, I'm
not sure if this has anything to do with me using CASE or not.

Any help, comments, and/or suggestions on this would be highly appreciated.
Thank you.

Regards,

- Rob.