• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Update MSSQL thru Excel

I have connected to SQL2008 table within excel and when I update a cell I expect the SQL field to also be updated. I have update, insert permissions selected for that table.
1 Solution
You can't do that easily.  

The most simple way in Excel is to have a stored procedure on your server - and send your update query through the stored procedure using some vba.  This also very much depends on your table having a unique key and being set up well
EEMPWAuthor Commented:
Thx for the help.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now