Q+E: Large Values in Money Field in ExcelFile Are Blank

• Q+E for Microsoft Excel for Windows, versions 3.0 and 3.0a (This product is available with Microsoft Excel for Windows versions 3,0 and 4.0).
• Q+E for Microsoft Excel, version 3.0 for OS/2 (This product is available with version 3.0 of Microsoft Excel for OS/2)

SUMMARY

In Q+E for Microsoft Excel, the Money data type used in the ExcelFile driver has a range of -5368709.11 to +5368709.09, with an accuracy of 1/100 (one one-hundredth) of a dollar. Any values that exceed these limits will appear blank in the query window.

In order to use values that are not within this range, you must change the field data type from Money to Float. With the Float data type you can use precision floating point values that can range from -1.00E50 to +1.00E50 (that is negative and positive 10 followed by 49 zeroes), with all decimal values included to the 15th decimal place.

MORE INFORMATION

The ExcelFile driver in Q+E was written with a special data type called Money. The Money data type is stored as a long integer, not as a floating point value. This Long Integer is then is displayed as if it were a 2 decimal place floating point calculation -- this limits the maximum and minimum values to the range specified above.

Note: The Money data type in the ExcelFile driver is different from the Money data type available on SQL Server. The SQL Server Money data type can contain dollar and cent values between +- 922,337,203,685,447.5807 with accuracy to 1/10,000 (one ten-thousandth) of a dollar.

REFERENCES

"Q+E for Microsoft Excel User's Guide," version. 4.0, pages 93 and 150