>>Does someone knows how to open programatically Microsoft Query in Excel ?
>>In Excel from the Data menu, choose Get External Data. Microsoft Query opens.
>>
>>A customer want to open Query window opens automatic from VFP so the enduser doesnt has to know about the stuff to connect to the server.
>>
>>I recorded a macro but when I was looking the code, nothing about Microsft Query was there.
>>
>>Thanks in Advance.
>>
>
>Peter,
>MS Query is designed to return result sets to Excel. Maybe you could VFP's DDE commands to work with it and do the same thing, I don't know. The MS Query Help gives all the DDE commands supported by it and some examples on how to use them.
>
>However, if you simply want an ad hoc query interface for your users, maybe one of the entries in the Downloads section will help. Use "query" in the Description field.
>
>HTH.

Larry,
Thanks for the answer but the way I see, I have to build my own Query Builder for the end user, because the interface must be in portuguese.
Anyway the user wants to export que data from SQL Server to Excel, and I wanted to make my life easier just using MS Query.
I just havent found a way to call the MS Query from VFP.

Tks.

Peter