sql - Excel doesn't save SQL query changes

Question

I'm having trouble with Excel saving changes I made in an embedded SQL query to connect it with a MS SQL Server. The connection is DSN-less.

When I delete a WHERE-statement, save the workbook, then close it and open it again and go to connections window to check my connections, my changes to the SQL query are not there anymore.

But now comes the strange part: When I execute the SQL query it is executed as if my changes are still in it.

I hope someone can help me

Thanks in advance! :)

标签： sqlexcelms-office

Answer 1

在数据库上创建一个查询视图。关注数据 -> 其他来源 -> 来自 excel 选项卡菜单上的 sql server。选择视图后 db 的用户名和密码。连接是数据选项卡上的连接。

如果要刷新，请使用数据选项卡上的刷新按钮。