批量更新 Excel 文件连接字符串 [英] Mass update Excel file connection string

问题描述

我们最近更改了我们的 SQL 数据库服务器，我想知道是否有更新所有 Excel 文件连接字符串的脚本或更简单的方法?

We have recently changed our SQL Database server and i was wondering if there would be a script or an easier method of updating all the Excel file connection strings?

如果他们使用连接文件会容易得多，但不幸的是它们都是手动设置的，我们有大约 600 份报告...

It would of been alot easier if they used a connection file but unfortunately they were all set manually and we have about 600 reports...

非常感谢任何帮助.

谢谢

尼克

推荐答案

我也想做同样的事情，结果从 这里.

I wanted to do the exact same thing and came accross this tool called XLODCTool from here.

文件链接这里.

您可以批量更改连接字符串中的值，例如

Allos you to bulk change values inside of a connection string e.g.

DSN 从 SERVERA 到 SERVERB

这篇关于批量更新 Excel 文件连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！