How to read a SQL Table into Excel change the data and write back into SQL
 

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

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