ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   append only new SQL db records via XLS qry (https://www.excelbanter.com/excel-programming/352922-append-only-new-sql-db-records-via-xls-qry.html)

Patience

append only new SQL db records via XLS qry
 
I have a qry which calls data from a SQL db and inserts it into an XLS
spreadsheet. However, once the data has been called, I manually enter a
supporting numeric code to the same sheet. The manually-entered code needs to
remain with the record I add it to.
However, when I refresh the data, the data shifts on the XLS sheet, and a
record is no longer on the same row as the code I manually entered.
I was thinking there may be a way to have the qry only insert new records,
and add them at the bottom of the spreadsheet so it doesn't re-sort (I don't
have any sort options set), but I don't know how to do that (or if it can be
done)?
Can someone help with this, or suggest a better solution?

Thanks!


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com