Hi @StevenHeinz , Thank you for reaching out to the Microsoft Community Forum.
If you're using Power Query in Excel or Power BI, the issue with "Copy Entire Table" is expected. That feature only copies the previewed rows, typically the first 1,000, not the entire dataset. To export all rows from your append query, the most reliable method is to load the query to a worksheet (in Excel) or to the data model (in Power BI). In Excel, go to Home -> Close & Load To -> Table and select a worksheet, this will load the full result of the query, which you can then save as a CSV. In Power BI, load the query to the data model, then create a table visual and use the "Export Data" option to export the full dataset (up to 150,000 rows), or use DAX Studio for exporting large datasets without row limits.
If you're working in Microsoft Access, an append query doesn’t produce a result set directly, so copying from the datasheet view only gets visible rows. To export the full data, open the append query in SQL View, copy the SELECT portion of the query and paste it into a new Select Query. Save it, then right-click and export the query to your desired format. This ensures all records based on the original query logic are included, regardless of how many are displayed in the viewer.
In both Excel and Access, if you frequently need to export data, you can automate the process using VBA. In Excel, after loading the data to a worksheet, a small macro can write the content to a CSV file. In Access, you can use DoCmd.TransferText to export a saved query directly to CSV format.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
