Recent content by 50gumby

  1. 5

    Importing Excel into Access Database

    The one record that didn't get imported has the value 202 in the Primary Key field. No other records contain this value. The data type is Short Text.
  2. 5

    Importing Excel into Access Database

    I already know there was one record that didn't get imported and I can't see anything wrong with it.
  3. 5

    Importing Excel into Access Database

    I tried to post the error message but am not having any results. So below is the text. Microsoft Access was unable to append all the data to the table. The contents of fields in 0 record(s) were deleted, and 92 records were lost due to key violations. If data was deleted, the data you pasted or...
  4. 5

    Importing Excel into Access Database

    Many thanks for that. Is there any function that informs you which record is the problem child? The record I tracked down doesn't seem to have any duplicates within the list.
  5. 5

    Importing Excel into Access Database

    OK - been playing with it. I import to a NEW table and there is no problem whatsoever. Why is this? Is there a problem with this function?
  6. 5

    Importing Excel into Access Database

    I've got a spreadsheet with the same field headers in Access and Excel. I go through the import process under the External Data tab. I get an error when I try to complete - seems to be a well-recognised error. When I compare the imported records in Access to the records in Excel, there is one...
Top Bottom