0

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel?

I have a user (the DBA, funny enough) that swears up and down that it's doable, but whenever he connects, the DB is not writable from excel. Tried with my account as well, but was unsuccessful. His account and mine both have rights to read and write to the database in question. Is there some service I need to enable?

From the information I can find with Microsoft, he excel/sql connection functions only as an import.

Justin
  • 167
  • 1
  • 3
  • 12

2 Answers2

1

It's doable. Whether it's a good idea or not is a whole other question, but it's doable.

For example, this, this, or this.

Community
  • 1
HopelessN00b
  • 53,385
  • 32
  • 133
  • 208
  • I think it's an awful idea, but it's the DBA's call, not mine. – Justin Jan 21 '14 at 16:56
  • @user1952483 Yup. If you want some help troubleshooting why you guys can't get it working, some specifics and SQL Server logs might be helpful... though if it were me, I'd just dump the answer that it's possible on the DBA, and make him worry about how to configure the SQL server to authenticate a user through an Excel spreadsheet (which would be my guess about where it's going wrong - the authentication pass-through from Excel). – HopelessN00b Jan 21 '14 at 17:18
-2

Try this. You will able to connect SQL Server data with Excel, edit it as spreadsheets and save it back in database

ClausW
  • 1
  • 2
    Link-only answers are discouraged. Please provide content **here** and then link elsewhere for more details if necessary. – EEAA Sep 29 '15 at 14:31