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.
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.
Try this. You will able to connect SQL Server data with Excel, edit it as spreadsheets and save it back in database