I have a workbook with a bunch of different SQL queries that I'm trying to update simultaneously. All the queries are very similar I just need to change a number in 12 different ones. I’ve been going in to each one through Connections>properties>definition>commandtext Rather than doing this for all 12 queries, I would rather use something like notepad and utilize find/replace then dump those back into excel. I have a link to a couple of screen shots of how I’m accessing them now. https://www.dropbox.com/l/dRp0P4oylY3NXmXQudPjie any help would be greatly appreciated!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel Connection SQL Server - multiple query updates

Thread starter Mountaineer00
Start date Apr 17, 2013
Tags

connections query update sql

Mountaineer00

New Member

Apr 17, 2013

I have a workbook with a bunch of different SQL queries that I'm trying to update simultaneously. All the queries are very similar I just need to change a number in 12 different ones.

I’ve been going in to each one through Connections>properties>definition>commandtext<o

></o

>
Rather than doing this for all 12 queries, I would rather use something like notepad and utilize find/replace then dump those back into excel. I have a link to a couple of screen shots of how I’m accessing them now.<o

></o

>

https://www.dropbox.com/l/dRp0P4oylY3NXmXQudPjie

any help would be greatly appreciated!