The information in this article applies to:
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
CAUSEWhen you import a Microsoft Excel spreadsheet into a new table, Microsoft Access checks the first row of the spreadsheet to determine the data types for the new table. If the first row of the spreadsheet contains a numeric value in a column that allows alphabetical and numeric characters, Microsoft Access will define the field type in the table for that column as numeric. If there are alphabetical characters in other rows in this column in the spreadsheet, this error message will occur. RESOLUTIONTo work around this behavior, insert an extra row of data as the first row in the spreadsheet. Insert alphabetical characters in any columns that are defined as alphanumeric columns. Enter numeric characters in any columns that are defined as numeric columns. After you have imported the spreadsheet into Microsoft Access, delete the extra row of data from the spreadsheet and the table. MORE INFORMATIONSteps to Reproduce Behavior
Keywords : kbinterop IsmExl4 |
Last Reviewed: May 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |