View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wrytat wrytat is offline
external usenet poster
 
Posts: 1
Default Update MS SQL 2000 from Excel

I know how to connect to the MS SQL 2000 Server to import data of a table to
the spreadsheet. But I'd like to find out how to update the table if I made
changes of the data on the spreadsheet. For example, when I add a row, the
table will get updated with the new record. If I delete certain row, the row
will also be removed from the table. And if I made any ammendments of the
data, the table will get updated as well. Can I do it real-time? Is that
possible to be done?