I have a query in an Excel worksheet. I am unable to limit the returned data. The query currently returns 25 records. I only want 20. I am able to sort the records in the query, and even limit the data returned on the edit query page, by using the 'options' menu and limiting the recurods returned to 20, but when I return the data to Excel, the query returns the full set of data to the spreadsheet. I have VB code that is looking in specific cells for the data returned, so i can't just have the query insert cells. The query is set to overwrite existing data and clear unused cells. I would change the Code but It would take several days as the code is several thousand lines, and I didn't write it. It is undocumented, and not very well written. It would be much faster to be able to limit the return of data from the Query.