Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    NE
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change DSN (2003)

    I have created a massive spreadsheet with many ODBC queries in it. It return information from our Accounting software. My issue is that it was created with one DSN but now I need to switch to another DSN (with the same tables and fields). If I create totally new queries it will lose all my formatting. Is there anyway to switch it to new DSN? I tried just switching the data folder that the DSN pointed to but Excel didn't register the change.
    Thanks for you help.
    S.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change DSN (2003)

    Check out my flexfind utility, it might just enable you to search and replace within the DSN's:
    http://www.jkp-ads.com/Download.htm
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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