ODBC Connector Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You posted in the programming newsgroups, so my suggestion pertained to a
programming solution.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a Picture From Cell Comment 0
tuncating a table in sql from excel 1
If ActiveCell has a comment then exit sub 22
Excel ODBC driver created table/inserted data lost on application 1
How to build / refresh pivot table without ODBC?? 1
Show Excel comment on mouseover but not the comment indicator 7
ODBC Password 1
excel odbc ms query using cell as criteria value 1

Back
Top