Field Names Replaced with FIELD1, FIELD2 if TEXT Function Used

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.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a spreadsheet with the following data:

         A1: =text(3,"#")
         A2:
         A3: customer name               B3: customer address
         A4: joe                         B4: 123 Oak St.
         A5: beth                        B5: 345 Main St.
   
   

2. 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.

3. 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.

REFERENCES

"Q+E for Microsoft Excel User's Guide." Version 3.0, pages 61-63.