WX1235: Interoperability Questions and Answers (7.0)

Last reviewed: October 21, 1997
Article ID: Q137347
The information in this article applies to:
  • Microsoft Access version 7.0

Moderate: Requires basic macro, coding, and interoperability skills.

The "Interoperability Questions and Answers" (WX1235) Application Note contains questions and answers about interoperability issues between Microsoft Access for Windows 95 version 7.0 and other software programs.

You can obtain this Application Note from the following sources:

  • Microsoft FastTips Technical Library
  • Microsoft Product Support Services

For complete information, see the "To Obtain This Application Note" section at the end of this article.

THE TEXT OF WX1235

  Microsoft(R) Product Support Services Application Note (Text File)
            WX1235: INTEROPERABILITY QUESTIONS AND ANSWERS
                                                   Revision Date: 9/95
                                                      No Disk Included

The following information applies to Microsoft Access, version 7.0.

 INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY
 ACCOMPANY THIS DOCUMENT (collectively referred to as an Application
 Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER
 EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED
 WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR
 PURPOSE. The user assumes the entire risk as to the accuracy and
 the use of this Application Note. This Application Note may be
 copied and distributed subject to the following conditions:  1) All
 text must be copied without modification and all pages must be
 included;  2) If software is included, all files on the disk(s)
 must be copied without modification (the MS-DOS(R)  utility
 diskcopy is appropriate for this purpose);  3) All components of
 this Application Note must be distributed together;  and  4) This
 Application Note may not be distributed for profit.

 Copyright (C) 1995 Microsoft Corporation.  All Rights Reserved.
 FoxPro, Microsoft, MS-DOS, and Windows are registered trademarks of
 Microsoft Corporation.
 dBASE and Paradox are registered trademarks of Borland
 International, Inc.  Lotus and 1-2-3 are registered trademarks of
 Lotus Development Corporation.
1. Q. What types of files can Microsoft Access for Windows 95 import
      or link?

   A. You can import and link the following file types in Microsoft
      Access for Windows 95:

       - Microsoft FoxPro(R) versions 2.0, 2.5, 2.6, and 3.0. (Note
         that you can only import 3.0 files; you cannot link them.)

       - dBASE(R) III, III+, IV, and 5.0.

       - Paradox(R) versions 3.x, 4.x, and 5.0.

       - SQL tables and data from programs and databases that support
         the ODBC protocol.

       - Microsoft Excel spreadsheets versions 2.x, 3.0, 4.0, 5.0, and
         7.0.

       - Lotus(R) 1-2-3(R) spreadsheets, .WKS, .WK1, and .WK3 formats.
         (Note that you can only import these files; you cannot link
         them.)

       - Delimited text files.

       - Fixed-width text files.

      For more information about importing and linking data, search
      on the phrase "What files can I import" then view "How Do I:
      Import or link data from other programs and file formats" using
      the Answer Wizard from the Microsoft Access Help menu.

2. Q. I do not see my file type in the list in the Import dialog box.
      Does that mean I cannot import it?

   A. No, usually you can import your file by first saving it as one
      of the file types supported by Microsoft Access. For example,
      most programs have a Save As or Export option for delimited
      text files or dBASE III+ files. You can save your file as one
      of these file types in the other program and then import it
      into Microsoft Access.

3. Q. Why can't I see my text file in the list when I try to import
      it?

   A. By default, Microsoft Access for Windows 95 filters the common
      text file extensions, such as .txt and .csv. To see files with
      other extensions, type *.* in the File Name box, and then press
      ENTER.

4. Q. What kinds of graphics files does Microsoft Access for Windows
      95 support?

   A. It depends on whether you are storing the graphics file as an
      OLE object or in the new image control. When you use a bound or
      unbound object frame, you can link or embed any file type that
      has an OLE Server program registered on your computer. For
      example, if you have a Windows-based program that supports .bmp
      files, such as Paint in Windows 95, and that program is an OLE
      Server program, you can embed or link that file in a bound or
      unbound object frame on a form or report.

      If you are using the new image control, you can use bitmaps
      (.bmp or .dib extensions) or metafiles (.wmf or .emf
      extensions).

      For more information about object frames and the image control,
      search on the phrase "When should I use an object frame vs. an
      image control" then view "Tell Me About: Which type of object
      frame should I use and should I embed or link my object?" using
      the Answer Wizard from the Microsoft Access Help menu.

5. Q. What ODBC drivers are included with Microsoft Access for
      Windows 95?

   A. Microsoft Access for Windows 95 contains drivers for:

       - Microsoft SQL Server.

       - Desktop Drivers (Microsoft Access for Windows 95, Microsoft
         FoxPro, dBASE, Microsoft Excel, Paradox, and Text Files).

      The Desktop Drivers are not used by Microsoft Access. They are
      installed by Microsoft Access so that other programs, such as
      Microsoft Excel, can gain access to Microsoft Access databases
      and other data files through ODBC. Microsoft Access uses built-
      in drivers called ISAMs to gain access to these file types.

6. Q. Can I add a Microsoft Access database to the Microsoft Office
      Binder?

   A. No, only Microsoft Word documents, Microsoft Excel worksheets
      and charts, and Microsoft PowerPoint presentations can be
      added. Although you cannot add a Microsoft Access database to a
      Binder, you can embed a Binder in an OLE field in a Microsoft
      Access table.

TO OBTAIN THIS APPLICATION NOTE

  • You can have this Application Note mailed or faxed to you from the automated Microsoft FastTips Technical Library, which you can call 24 hours a day, 7 days a week at (800) 936-4100. NOTE: The FastTips Technical Library is available only to customers within the U.S. and Canada.
  • If you are unable to access the source(s) listed above, you can have this Application Note mailed or faxed to you by calling Microsoft Product Support Services Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time at (425) 635-7050. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, please see the Microsoft World Wide Offices Web Site at:

          http://www.microsoft.com/worldwide/default.htm
    
Keywords          : Fstqa Softlib kbappnote kbfile kbfasttip
Version           : 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo


================================================================================


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: October 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.