+ Reply to Thread
Results 1 to 2 of 2

external data - cleanup existing connections

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    8

    external data - cleanup existing connections

    While making my first foray into defining external connections (to an Oracle database) I ended up with an "Existing Connection" that reports "File could not be opened. It is either damaged or the file format is not valid. Try opening the application that created it and saving to a new file." Followed by "Unable to open or read this connection file. Either the file has been damaged or the file format is not valid."

    Ok, fine. So how do I delete it? There seems to be no option for that in the "Existing Connections" dialog. A search for a *.odc or *.udcx file doesn't turn up anything with the name of this connection. A search of the registry doesn't turn up anything.

    extdata.jpg

  2. #2
    Registered User
    Join Date
    04-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: external data - cleanup existing connections

    I found it ... well, *a* method ...
    Turns out I had created the connection with "MS Query" (From Excel -- Data -> From Other Sources -> From Microsoft Query). I went there because it mentioned ODBC, and I had already set up an ODBC dsn. Going back there, I was able to select to "Open", and saw my connection listed as a *.dqy file. Odd, going back to search the drive for *.dqy files got no hits, but the Open Query dialog allowed me to right-click the file, then select to delete it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1