ACC: Output to XLS Changes Text to Scientific Notation Number (180590)
The information in this article applies to:
- Microsoft Access 2.0
- Microsoft Access 97
This article was previously published under Q180590 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you output a Microsoft Access report to Microsoft Excel file format, a
text string that is made up of both alphabetical and numeric characters may
be changed to a number, and this number may appear in scientific notation
when you open the spreadsheet file in Microsoft Excel. You may also see
this behavior when you click the Analyze It With MSExcel button while you
are previewing a report.
CAUSE
In some cases, Microsoft Access may recognize a text string as a
hexadecimal number when it outputs a report to Microsoft Excel (*.xls) file
format. The problem can occur with a text string containing the letter "e"
in a Microsoft Access 2.0 report, or with a text string containing the
letter "d" or the letter "e" in a Microsoft Access 97 report.
RESOLUTION
Note that you may also see this behavior when you try to save a report as a
spreadsheet file by opening it or selecting it in the Database window,
clicking Save As/Export on the File menu, and then choosing To An External
File or Database. Because this problem occurs whenever you try to save a
report as a spreadsheet file, you should export the underlying table or
query to Microsoft Excel if possible. To export a table or query to
Microsoft Excel, follow these steps.
In Microsoft Access 2.0- On the File menu, click Export.
- In the Data Destination list of the Export dialog box, click Microsoft Excel 2.0-4.0 or Microsoft Excel 5.0. Then click OK.
- In the Select Microsoft Access Object dialog box, click the object that you want to export, and click OK.
- In the Export To File dialog box, choose a directory and type a name
in the File Name box. Then click OK.
In Microsoft Access 97- In the Database window, select the table or query that you want to export.
- On the File menu, click Save As/Export.
- In the Save As dialog box, click "To an External File or Database," and then click OK.
- In the "Save <objectname> In" dialog box, select the folder to which you want to export the file.
- From the Save As Type list, select the version of Excel to which you
want to export the file.
- Type a name in the File Name box, and then click Export.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbbug kbnofix KB180590 |
---|
|