October 10, 2013 at 7:21 am
Hi, simple question:
Is it possible to connect to a SQL 2008 Db table with ms excel 2010, and edit the fields directly from excel?
Like the same way as when you edit a table in ssms.
Thanks in advance.
October 10, 2013 at 7:31 am
niklasrene (10/10/2013)
Hi, simple question:Is it possible to connect to a SQL 2008 Db table with ms excel 2010, and edit the fields directly from excel?
Like the same way as when you edit a table in ssms.
Thanks in advance.
Not directly no (thank god), but you can code it yourself using VBA for example.
Editing an SQL Server table in Excel
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 8:40 am
You don't say exactly what it is you are trying to do, but you can bring Excel data into a SQL database using SSIS and you can do whatever with it from there. Maybe with more details we can help with a better solution.
October 14, 2013 at 8:44 am
I really hope MS never allows Excel to directly edit a SQL Server table - that could end up being a complete disaster for DBAs everywhere.
October 14, 2013 at 9:59 am
http://www.toadworld.com/platforms/sql-server/w/wiki/10392.editing-an-sql-server-table-in-excel.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 14, 2013 at 10:06 am
J Livingston SQL (10/14/2013)
http://www.toadworld.com/platforms/sql-server/w/wiki/10392.editing-an-sql-server-table-in-excel.aspx
<sarcasm>
That's just beautiful. It even features a hard-coded connection string complete with the server, database, username and password. What could possibly go wrong? :w00t:
</sarcasm>
Yes, it's a programmed approach to solve a problem, but I think the problems it could create outweigh the benefits.
October 14, 2013 at 12:36 pm
Ed Wagner (10/14/2013)
I really hope MS never allows Excel to directly edit a SQL Server table - that could end up being a complete disaster for DBAs everywhere.
+1000
It's not because you can, that you should. 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply