XL: Cannot Access Local Databases with Data Access Macro

 Last reviewed: February 2, 1998
Article ID: Q93531
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0

SUMMARY

You cannot use the Microsoft Excel Data Access Macro (DAM) to query local databases (databases that are located on your own computer). The DAM will not access local databases because it uses the Macintosh Data Access Language (DAL) which only allows Microsoft Excel and the DAM to access remote databases (databases that are stored somewhere other than your computer).

In order to use the Microsoft Excel Data Access Macro (DAM) to access a local Macintosh database you must use a special third-party version of the DAL software.

MORE INFORMATION

The DAM is a front-end viewer for Microsoft Excel for the Macintosh and the DAL client-server database engine. The DAM passes American National Standards Institute (ANSI) Structured Query Language (SQL) queries to the DAL client software which then passes them on to the DAL server. (The DAL server is a host computer containing the DAL server software, a particular database management system (DBMS), and specific data tables.)

Some third-party manufacturers offer their own versions of DAL software that allows access to local files. EveryWare Development Corporation, for example, makes the Butler DAL Server. For more information about the Butler DAL Server, contact: 

    EveryWare Development Corporation
    6543 Missisauga Road
    Missisauga, Ontario (Canada)
    L5N 1A6
    Phone: (905)819-1173
    FAX: (905)819-1172
    AppleLink: EveryWare
    CompuServe: 70750,211
The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.

The Butler DAL Server is manufactured by EveryWare Development Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: 3.00 4.00 novell db2 db/2 rdb oracle
ingres 3rdparty
Keywords : kbnetwork
Version : MACINTOSH: 3.0, 4.0
Platform : MACINTOSH
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: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.