| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write data back from a form to sheet | Excel Discussion (Misc queries) | |||
| How do I change a file from read only back to total access? | New Users to Excel | |||
| OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions | |||
| How to write back a SQL Server table from Excel | Excel Programming | |||
| Read/Write data to/from text files from a spreadsheet. | Excel Programming | |||
Linear Mode
