#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recent ODBC problem linking to CSV data Safety in numbers Excel Discussion (Misc queries) 2 September 4th 06 05:05 PM
ODBC Lynn Excel Discussion (Misc queries) 3 November 1st 05 04:16 PM
Problem writing Excel formulas via ODBC srikantha Excel Worksheet Functions 1 June 21st 05 06:28 PM
Problem writing Excel formulas via ODBC srikantha Excel Discussion (Misc queries) 0 June 21st 05 08:24 AM
MS Query/ODBC/SQL problem Jen Excel Discussion (Misc queries) 0 December 3rd 04 03:11 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"