The information in this article applies to:
SYMPTOMSWhen you import a Microsoft Excel version 4.0 spreadsheet containing custom date formats into a new Microsoft Access version 1.x table, Microsoft Access gives the fields Double data types, instead of Date/Time data types. STATUSThis behavior no longer occurs in Microsoft Access version 2.0. MORE INFORMATIONSteps to Reproduce Behavior
REFERENCESFor more information about importing Microsoft Excel data, search for "Excel" using the Microsoft Access Help menu.
Keywords : kbinterop IntpOff IsmExl4 |
Last Reviewed: March 12, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |