Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Sep 2001
    Location
    Birmingham, Alabama, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    moving Database Queries to a new computer (Excel 2003)

    I have recently acquired a new computer. I have moved all of my settings, my dictionary and Macros to the new machine. The one thing I can not seem to find is how to access the hundred or so database queries that are on the old machine. I would think they were in a file somewhere but I sure can

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: moving Database Queries to a new computer (Excel 2003)

    It depends on how you created them. If you stored them as separate files, they'll probably have extension .dqy, and the default folder is My Data Sources under My Documents.

  3. #3
    Lounger
    Join Date
    Sep 2001
    Location
    Birmingham, Alabama, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving Database Queries to a new computer (Excel 2003)

    Hans,

    The only .dqy files I can find on the old computer are in the directory:

    cocuments and SettingsUSERApplication DataMicrosoftQueries

    There were three files and I copied them to the same folder on the new computer. The queries were still not available.

    I added the original queries by selecting "Data" form the menu, then

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: moving Database Queries to a new computer (Excel 2003)

    What you describe is not a database query, but a data source. Data sources come in three types:

    1) User data sources are available only to the user that created them. They are stored in the Windows registry, under HKEY_CURRENT_USERSoftwareODBCODBC.INI. You can use RegEdit to export this registry branch to a .reg file, and import it on another PC.

    2) Machine data sources are available to all users of the PC. They are also stored in the Windows registry, under HKEY_LOCAL_MACHINESoftwareODBCODBC.INI. Same export/import routine.

    3) File data sources are stored in files with extension .dsn, by default in C:Program FilesCommon FilesODBCData Sources. You can copy the .dsn files to another PC.

  5. #5
    Lounger
    Join Date
    Sep 2001
    Location
    Birmingham, Alabama, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving Database Queries to a new computer (Excel 2003)

    Hans,

    Thans for the help. You are of course correct they are data sources and not queries. I found the files I needed in the Data Sources directory.

    Again, thanks for the help

    Milton

Posting Permissions

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