Microsoft KB Archive/74522

{| = Field Names Replaced with FIELD1, FIELD2 if TEXT Function Used =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74522

SUMMARY
Q+E may not be able to read a database on an Excel spreadsheet if you have used the TEXT function above or to the left of the area defined as the database.

When importing the file into Q+E or extracting data from it using the add-in macro QE.XLA, you may get the field headings FIELD1, FIELD2, and so on instead of the correct headings.

This problem does not occur in Q+E for OS/2.

Steps to Reproduce Problem
  Create a spreadsheet with the following data: A1: =text(3,&quot;#&quot;) A2: A3: customer name B3: customer address A4: joe B4: 123 Oak St. A5: beth B5: 345 Main St.  Select the range A3:B5. From the Data menu, choose Set Database to define this as a database. Save the file as SHEET1.XLS and close it. Open SHEET1.XLS in Q+E. It will have FIELD1 and FIELD2, but no data.

Workaround

 * 1) Enter the text function in a cell located below or to the right of a defined database in a source spreadsheet. Save the file and close it. The correct field names with data will result when querying SHEET1.XLS in Q+E.