![]() |
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