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?
|