ACC2000: MS Excel Currency Displayed Incorrectly in Import Wizard (210615)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q210615
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. There may be extra zeros to the right of the decimal place in the sample data. However, when you open the resulting table, you see that the data has been imported correctly.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Microsoft Excel. On Sheet1 of the new workbook, type the following data:

    A1: $1.00
    A2: $2.00
    A3: $3.25

  2. Save the workbook as C:\My Documents\XLImport.xls, and then close it.
  3. Start Microsoft Access, and open the sample database Northwind.mdb.
  4. On the File menu, point to Get External Data, and then click Import.
  5. In the Import dialog box, select Microsoft Excel from the Files Of Type list.
  6. Locate the folder, C:\My Documents, select the XLImport.xls file, and then click Import.
Note that the sample data in the Import Spreadsheet Wizard is not displayed correctly. There are four zeros to the right of the decimal place. However, if you click Next until you reach the fourth screen of the Import Spreadsheet Wizard, you see that the Data Type list, although disabled, does display Currency. Also, if you click Finish and open the resulting table, you see that the data has been imported correctly.

REFERENCES

For more information about importing or linking data from Excel, click Microsoft Access Help on the Help menu, type import data from a spreadsheet in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbinterop kbpending KB210615
©2004 Microsoft Corporation. All rights reserved.