ACC: Number Field with Input Mask Appears as Text in Microsoft Excel (161331)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q161331 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you export a table to Microsoft Excel using the OutputTo macro action
or a Visual Basic method, Number fields that have an input mask appear as
Text fields in Microsoft Excel.
CAUSE
When a field in a table uses an input mask, Microsoft Access outputs the
data in a custom format. The custom format causes the indexed sequential
access method (ISAM) driver for Microsoft Excel to treat the field as Text.
RESOLUTION
If you want to maintain your data as a Number field, use the Save
As/Export command on the File menu. If you only want the data in Microsoft
Excel to look the same as it does in Microsoft Access, you can use
OutputTo.
REFERENCES
For more information about the OutputTo action or method, search the Help
Index for "OutputTo action" or "OutputTo method."
Modification Type: | Major | Last Reviewed: | 11/4/2003 |
---|
Keywords: | kbinterop kbprb KB161331 |
---|
|