XL: Cannot Access Local Databases with Data Access Macro

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: novell db2 db/2 rdb oracle ingres 3rdparty

Keywords : kbnetwork
Version : MACINTOSH: 3.0, 4.0
Platform : MACINTOSH
Issue type : kbinfo


Last Reviewed: July 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.