Microsoft KB Archive/92746

{|
 * width="100%"|

PRA: Table Export to Excel Does Not Set Database Name
'Article ID: Q92746

Creation Date: 15-NOV-1992

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access version 1.0
 * Microsoft Excel for Windows, version 4.x

SYMPTOMS

When you export a table from Microsoft Access to Microsoft Excel, the defined name &quot;Database&quot; is not set in Microsoft Excel.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION

To use the exported data as a Microsoft Excel database, the database range must be set manually in Microsoft Excel. This can be done by highlighting the entire set of data, including the first row of labels, and choosing Set Database from the Data menu.

For more information on interactions between Microsoft Access and Microsoft Excel, query on the following words here in the Microsoft Knowledge Base:

access and excel and database and biff NOTE: BIFF is the Microsoft Excel Binary Information File Format.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00

KBCategory: kbinterop

KBSubcategory: IsmExl4