ACC2: Import Errors Table Lists Incorrect Row NumbersLast reviewed: May 30, 1997Article ID: Q148466 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. When you import a spreadsheet that causes a "key violation" error, the resulting Import Errors table lists row numbers one greater than the actual spreadsheet row. For example, if row 2 from the spreadsheet file causes a key violation, then it is listed in the Import Errors table as row 3 (not row 2).
RESOLUTIONYou can manually subtract 1 from the row numbers listed for "key violation" errors in the Import Errors table.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information about the Import Errors table, search for "import errors," and then "import errors table" using the Microsoft Access Help menu. |
Keywords : IsmProb kb3rdparty
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |