Setting the Default Driver for File Open in Q+E

 Last reviewed: November 3, 1994
Article ID: Q71776
The information in this article applies to:
  • Microsoft Excel for Windows, version 3.0

Summary:

It is possible to set the default database driver for the File Open command in Q+E for Microsoft Excel by modifying the connect= option in your WIN.INI file.

More Information:

The connect= option in your WIN.INI file is used to inform Q+E which driver to select by default when you choose to open a file.

To make Q+E use a driver other than the one that is set up during installation, use a text editor such as Notepad to change the text that follows the connect= line to the name of another valid driver. Valid driver names will be listed in the [SQLCONNECT] section of WIN.INI. You will need to restart Windows for these changes to take effect.

For example, the following is an example of WIN.INI immediately after Q+E is installed with the dBASEFile driver set up as the default: 

   [SQLCONNECT]
   ExcelFile=QEXLS
   SQLServer=QESS
   dBASEFile=QEDBF
   TextFile=QETXT

   [Q+E]
   connect=dBASEFile
   NoLogon=dBASEFile,TextFile,ExcelFile
   Maximized=1
   AsciiOem=0
If you usually open Microsoft Excel files in Q+E, you will want to change the "connect=dBASEFile" line to "connect=ExcelFile" (without the quotation marks): 

   [SQLCONNECT]
   ExcelFile=QEXLS
   SQLServer=QESS
   dBASEFile=QEDBF
   TextFile=QETXT

   [Q+E]
   connect=ExcelFile
   NoLogon=dBASEFile,TextFile,ExcelFile
   Maximized=1
   AsciiOem=0

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.0 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.