Microsoft KB Archive/76782

{| = UAE When Extracting Data from Two External Excel Databases =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q76782

SUMMARY
An Unrecoverable Application Error (UAE) may occur in Q+E when you try to do an extract from two external databases if one of the databases contains more than 15 fields.

This behavior does not occur with Q+E and Excel 3.00 for OS/2; it only occurs when accessing Excel for Windows worksheets.

MORE INFORMATION
The functionality to connect to external databases is provided by Q+E and the add-in macro QE.XLA. For more information about the macro functions provided by QE.XLA, see &quot;Q+E for Microsoft Excel User's Guide.&quot;

Steps to Reproduce Problem
 Create two databases, each on its own sheet, and define the Database range on each sheet. Make one short (only two fields) and the other long (20 or more fields). Make one of the fields common to both databases. The field heading does not need to be the same but data in at least one record must match to receive any records when the join is performed. For this example, we called the first field &quot;NAME&quot; and entered a record with the same name in each database. Save the first sheet as TEST1.XLS. Save the second as TEST2.XLS Open new worksheet. Open the QE.XLA add-in. Choose Set Database from the Data menu. Select External and choose TEST1.XLS. Then choose the option Add and select TEST2.XLS.  Enter the following: A1     TEST1.NAME A2     TEST2.NAME  Highlight the range A1:A2 and choose Set Criteria from the Data menu.</li> To create the extract range, select cell A4 and choose Paste Fieldnames from the Data menu.</li> While the pasted range is still highlighted, choose Extract from the Data menu. At this point the UAE will occur.</li></ol>

Extract seems to work consistently if the long database has 15 or fewer fields. The UAE does not always occur at 16 fields. You may be able to have up to 20 fields in the larger database before the UAE occurs. For more information, query on:

related and database and tables