ACC: Microsoft Excel Currency Displayed Incorrectly in Import Wizard (171073)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q171073 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you import a Microsoft Excel spreadsheet into Microsoft Access,
currency is not displayed correctly in the Import Spreadsheet Wizard. The
dollar signs ($), as well as the zeros to the right of the decimal place,
are missing from the sample data. However, when you open the resulting
table, you see that the data has been imported correctly.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and
Microsoft Access 97.
REFERENCES
For more information about the Import Spreadsheet Wizard, search the Help
Index for "Microsoft Excel, importing and linking Excel data," and then
select "Import or link data from a spreadsheet."
Modification Type: | Major | Last Reviewed: | 10/22/2003 |
---|
Keywords: | kbbug kbinterop KB171073 |
---|
|