数百个Excel文件的SQL数据库连接的批量更改？ [英] Bulk changes of SQL database connections for hundreds of Excel files?

问题描述

大家好，

我们需要更改数百个Excel文件的SQL数据库连接。手动逐个更改每个Excel文件中的数据库连接将是一项巨大的工作。有没有办法在批处理模式下一次更改所有Excel
文件的数据库连接？所有数百个Excel文件中的数据库连接字符串都相同，并将更改为新文件。下面的截图可供参考。

谢谢，

高麻雀

解决方案

您好
高麻雀，

根据您的描述，我们可能需要使用代码来实现此要求。但在这里我们主要关注有关Excel客户端的一般问题，因此我们将您的主题移至以下MSDN论坛以获得更好的响应：

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

最好的问候，

Yuki Sun

Hi All,

We have a requirement to change the SQL database connections for hundreds of Excel files. It will be a huge job to change the database connections in each Excel files one by one manually. Is there a way to change the database connections for all the Excel files at one time in a batch mode? The database connection strings in all the hundreds of Excel files are the same and will be changed to a new one. Below screenshot can be for reference.

Thanks,
高麻雀

解决方案

Hi 高麻雀,

According to your description, we might need to use code to realize this requirement. But here we mainly focus general questions about Excel client, so we'll move your thread to the following MSDN forum for Excel for better response:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Best regards,
Yuki Sun

这篇关于数百个Excel文件的SQL数据库连接的批量更改？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！