Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171073

From BetaArchive Wiki

Article ID: 171073

Article Last Modified on 1/20/2007



APPLIES TO

  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition



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.

MORE INFORMATION

Steps to Reproduce Problem


  1. Start Microsoft Excel. On Sheet1 of the new workbook, enter 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 as currency. The dollar signs, as well as the zeros to the right of the decimal place, are missing. However, if you click the Next button 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 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."


Additional query words: zeroes

Keywords: kbbug kbinterop KB171073