Thread: How to read a SQL Table into Excel change the data and write back into SQL
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.programming
Uri Dimant Uri Dimant is offline
external usenet poster
  
Posts: 2
Default How to read a SQL Table into Excel change the data and write back into SQL
Belinda
Use DTS in SQL Server

"Belinda" wrote in message
om...
I want to use Excel as a frontend to maintain a few SQL tables. All I
want to do is read the contents of the SQL Server Table into a Excel
worksheet within Excel now I want to change, add or delete entries and
writeback this data into the SQL Server table.

Please would you be kind enough to share the workbook by emailing me
such a sample workbook or posting the code that can do this.

Thanks
Belinda


Reply With QuoteReply With Quote