| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC Connector Help
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ODBC Connector Help
Delete the entirecolumns or entirerows for the SQL data area.
-- Regards, Tom Ogilvy "Adurr" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ODBC Connector Help
Where can I find these options, I did not seem them?
"Tom Ogilvy" wrote: Delete the entirecolumns or entirerows for the SQL data area. -- Regards, Tom Ogilvy "Adurr" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ODBC Connector Help
You posted in the programming newsgroups, so my suggestion pertained to a
programming solution. -- Regards, Tom Ogilvy "Adurr" wrote: Where can I find these options, I did not seem them? "Tom Ogilvy" wrote: Delete the entirecolumns or entirerows for the SQL data area. -- Regards, Tom Ogilvy "Adurr" wrote: 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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ODBC Connector Help
Thank you, yes, I know I posted in the Programming newsgroup, my question is
how to I tell SQL to delete the entire row in Excel. When I delete the row in SQL now, it removes the row from SQL and Excel, what it does not remove the external data that I add after the import is complete. "Tom Ogilvy" wrote: You posted in the programming newsgroups, so my suggestion pertained to a programming solution. -- Regards, Tom Ogilvy "Adurr" wrote: Where can I find these options, I did not seem them? "Tom Ogilvy" wrote: Delete the entirecolumns or entirerows for the SQL data area. -- Regards, Tom Ogilvy "Adurr" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shape number for a connector? | Excel Programming | |||
| Comment Connector format | Excel Discussion (Misc queries) | |||
| Connector | Excel Discussion (Misc queries) | |||
| Excel Connector Lines | Charts and Charting in Excel | |||
| Application.wait & Blinking Connector | Excel Programming | |||
Hybrid Mode
