Amending database query reference in Excel 2000

[AndyHorn]

I've just replaced an old server. The new server has a new name but all the data has been kept in the same folder structure.

I have many excel spreadsheets that get their data from access databases on this server.

Is there an easy way to change the UNC path of the queries within the spreadsheet so they aren't looking for the database on the old server?

 

[kjv1611]

Can it not be changed under "Data Sources (ODBC)" under "Administrative Tools" in the Windows Control Panel?

 

[xlbo]

depends how the queries have been set up

if they are querytables then you can either amend the .dqy files that hold the connectin info or you can amend the connection via vba:

msgbox activesheet.querytables(1).connection

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question