ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ODBC Problem (https://www.excelbanter.com/excel-discussion-misc-queries/148164-odbc-problem.html)

Adurr

ODBC Problem
 
We have and ODBC connector to a SQL database and inserts data into Excel, in
addition we have added columns to the Excel Spreadsheet to add comments.
When an item is deleted from SQL, the Excel Spreadsheet updates and removed
the entry but keeps the comments, therefore associating the comments with the
wrong entry. Is there a way to remove the comment cells as well as the SQL
cells all once.


All times are GMT +1. The time now is 08:09 AM.

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