Changing database link using script editor

E

ed-wf

I need to change the database name for many pivot tables in a workbook. I
can change many of these in the script editor, but certain ones keep
reverting to their original link. See the portion starting DBQ=. I can edit
this in some cases, but not others.

x:Connection>DSN=MS Access Database;DBQ=G:\Customer Experience\Reporting\SAS
Generated\Report processing\reporter.mdb;DefaultDir=G:\Customer</x:Connection>
<x:Connection> Experience\Reporting\SAS Generated\Report
processing;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;</x:Connection>
<x:CommandText>SELECT `survey output ytd`.SURVEY_ID, `survey output
ytd`.TEXT, `survey output ytd`.QU, `survey output ytd`.ans, `survey output
ytd`.resp, `survey output ytd`.pct, `survey output ytd`.custpart
FROM `</x:CommandText>
<x:CommandText>survey output ytd` `survey output ytd`
WHERE (`survey output ytd`.QU=5)</x:CommandText>
 

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

Linking to Access tables using UNC paths 0
Mail Merge Functionality 0
HELP JOEL: auto populate certain userform fields from access datab 0
Querying an Excel File with a changing file name 1
Open Excel from Access 1
Refresh Excel Sheet with Access Data Frequently 0
Error Querying Access Database From Excel 0
Help with using ADO to connect Excel to Access 4

Top