you have had a number of views, but no responses. This is most likely because you have not provided enough information for anyone to provide a meaningful response. The sort of thing we need to know is what does your excel file and contacts table look like - order of fields/columns is important. What happens when you click yes? - the error message implies there won't be a problem - but is there actually a problem?
Check your spreadsheet to see if you have alphanumeric data in a column defined as numeric. If so, change it to text format. In the Access DB, make sure the column data types agree with the spreadsheet columns.
Last edited by davegri; 03-17-2019 at 01:53 PM. Reason: grammar
error message says no records are lost - my guess is the number of columns in the spreadsheet do not agree with the number of fields in the table and/or are in the wrong order
Things I would check in the spreadsheet:
1. None of the column header names are Access reserved words.
2. None of the column header names are repeated.
3. None of the column header names contain special characters like / or % or $ or @ or # and such.
1 and 3 above also apply to the new field names added to the contacts table in your DB.