 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008writeback to SQL 2005
hello! I use excel 2007 iI open a connection agianst SQL server 2005 and choose a table. In my workbook i can now see this data from this table. if i change a value in some cell i wish to writeback to table in SQL server. Is this possible? It's possible through the use of VBA and ADO, but not simply using the data connection you've already established. Ross > hello! I use excel 2007 > iI open a connection agianst SQL server 2005 and choose a table. In my > workbook i can now see this data from this table. if i change a value in > some > cell i wish to writeback to table in SQL server. Is this possible? Why does not microsoft have such in excel? Several 3 part has it like : http://www.excel-db.net/sql_server.htm and http://pcwin.com/Business___Finance/Excel_MS_SQL_Server_Import__Export___Convert _Software/index.htm > It's possible through the use of VBA and ADO, but not simply using the data > connection you've already established. [quoted text clipped - 6 lines] > > some > > cell i wish to writeback to table in SQL server. Is this possible?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.