Retrieve data

Whereas DDERequest can return data to a program, the Fetch and Fetch.Advise commands deserve special mention because they retrieve data from Microsoft Query and send it directly to a worksheet or document. Fetch and Fetch.Advise are used as the command argument to DDEExecute.

Fetch.Advise is similar to Fetch, except that the channel created by the first retrieval isn't closed immediately. Microsoft Query continues to send any changes to the data until the original DDE channel is closed or until Microsoft Query receives a Fetch.Unadvise command.