Microsoft KB Archive/136526

{|
 * width="100%"|

XL: Using 16-Bit and 32-Bit ODBC Drivers

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for Windows NT, version 5.0
 * Microsoft Excel for Windows, version 7.0
 * Microsoft Excel 97 for Windows
 * Microsoft Query for Windows, version 1.0
 * Microsoft Query for Windows 95, version 2.0
 * Microsoft Query 97 for Windows

-

SUMMARY
With Microsoft Excel and Microsoft Query, the Open Database Connectivity (ODBC) drivers that you may use depend on the operating system you are using and whether the program is the 16-bit or 32-bit version.

Microsoft Windows NT
If you are running Windows NT, 16-bit programs can use either 16-bit or 32- bit ODBC drivers. 32-bit programs can use only 32-bit ODBC drivers.

Microsoft Windows 95
If you are running Windows 95, 16-bit programs can use only 16-bit ODBC drivers and 32-bit programs can only use 32-bit ODBC drivers.

The following table lists when to use 16-bit or 32-bit ODBC drivers.

                           Windows NT  Window NT  Windows 95  Windows 95

Program                      16-bit      32-bit     16-bit      32-bit driver     driver     driver      driver ---

Microsoft Excel 5.0 for Windows 3.1       x           x          x           x

Microsoft Excel 5.0 for Windows NT                    x                      x

Microsoft Excel 7.0 for Windows 95                    x                      x

Microsoft Excel 97 for Windows                        x                      x

Microsoft Query 1.0 for Windows 3.1       x           x          x

Microsoft Query 1.0 for Windows NT **     x           x          x

Microsoft Query 2.0 for Windows 95                    x                      x

Microsoft Query 97 for Windows                        x                      x

with Microsoft Excel 5.0 for Windows NT is 16-bit. Additional query words: 8.00 97 xl97 DAO 16bit 32bit MSQuery XLODBC.XLA
 * Microsoft Query version 1.0 that is provided

Keywords : kbualink97 xlquery

Version : WINDOWS:1.0,2.0,5.0,5.0c,97; Win95:7.0; winnt:5.0

Platform : Win95 WINDOWS winnt

Issue type : kbinfo

Technology :