Microsoft KB Archive/70745

{| = DB.SQL.QUERY Requires Destination Number in Excel =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q70745

SUMMARY
When using the DB.SQL.QUERY function with a TYPE of three, the argument DESTINATION must be specified.

The query will also fail if the second argument, QUERY, is not enclosed in double quotation marks (&quot;).

MORE INFORMATION
When you specify a filename that contains the query you are trying to pass to Q+E, you must specify a destination number for the extracted records. If no destination number is selected, the result of the query will not appear on your active sheet.