file data source name in obdc

[koresnordic]

I have recently changed computers and need to update an old excel spreadhseet. The problem is that it contains a link via odbc to an access database. When I ask for the data to be refreshed, I get a data source not found error. Is there any way I can see what the name was?, as I know which database it was connected to, but cannot remember what the source name was.

Graham

 

[SkipVought]

Hi,

Try Edit/Links and see if you can find the link that needs to be changed. Skip,
Skip@theofficeexperts.com

 

[koresnordic]

The problem is, it is not a link but an odbc call. Edit>links is greyed out.

Graham

 

[SkipVought]

Is it an MS Query? In whch case you can Data/Import External Data/Edit Query Skip,
Skip@theofficeexperts.com

 

[koresnordic]

Hi Skip,
Tried that - I see msquery open, but I then get the same message. Clicking OK (the only option - although it is not ok) closes msquery.

Graham

 

[SkipVought]

I am at a loss. Unless you can find the link from your original computer, I have no other suggestions. :-( Skip,
Skip@theofficeexperts.com