How do I change my DSN without recreating the odbc connection?

P

plato

OK so get this, apparently we are to switch to ms active directory which
means that all the data sources need to be renamed.

I have a list of over 60 excel files using around 6-7 pivot tables each, and
all i need to do is change the dsn data source system name!!!!

is there any way to do this without having to recreate the dammed dsn for
every pivot table? Is there maybe a script that I could write ???

SOMething ... someone please help, this will take more than a year for me to
redo ... ugh ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Connection files and pivot tables 0
ODBC DSN query issue 1
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
dsn issue with windows 7 1
Connect to SQL with DSN without uid and password 2
Connect to SQL with DSN without uid adn password 1
ODBC Connection 0

Top