The information in this article applies to:
SUMMARY
Microsoft Excel for the Macintosh is shipped with an add-in macro
called the Data Access Macro. This macro allows Microsoft Excel to use
Apple Computer's Data Access Language (DAL) extension. You can use
this macro to access data from external databases and transfer query
results to Microsoft Excel worksheets or separate files.
MORE INFORMATION
If you are using the Data Access Macro, you need the following to
perform a successful query to an external database:
- The Data Access Macro. This macro is available with all versions of Microsoft Excel for the Macintosh versions 2.2 and later. The Data Access Macro does not work with versions of Microsoft Excel earlier than version 2.2. - The DAL system extension. This system extension is provided by Apple Computer. (Microsoft Excel version 2.2 shipped with a version of the DAL system extension which can be installed by running the CL/1 installer.) NOTE: The Data Access Macro does not come standard on the Academic version of Microsoft Excel, but may be obtained from Microsoft Customer Service at (800) 426-9400. - The Data Access software provided by Apple Computer. This software must be installed on the external database server. - Network connections from the Macintosh to the external database server. For more information about using or purchasing the DAL, contact Apple Computer, Inc. The Data Access Language is manufactured by Apple Computer, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability. REFERENCES"Microsoft Excel Database Access User's Guide," version 4.0, pages 1-4"Microsoft Excel Database Access User's Guide," version 3.0, for the Macintosh, pages 1-3 Additional query words: DAM
Keywords : kbenv |
|
Last Reviewed: August 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |