Results 1 to 7 of 7
  1. #1
    ARDE is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    3

    error importing excel data into access contacts


    I am having an error importing excel data into access contacts. The contact data base has been expanded to include some y/n fields. and I am trying to add records without these fields. Here is the error Click image for larger version. 

Name:	screen shot (2).jpg 
Views:	14 
Size:	230.1 KB 
ID:	37873

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    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?

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    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

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    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

  5. #5
    ARDE is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    3
    [QUOTE=ARDE;425361]I am having an error importing excel data into access contacts. The contact data base has been expanded to include some y/n fields. and I am trying to add records without these fields. Here is the error Click image for larger version. 

Name:	screen shot (2).jpg 
Views:	14 
Size:	230.1 KB 
ID:	37873

  6. #6
    ARDE is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    3
    Click image for larger version. 

Name:	screen shot 1.jpg 
Views:	6 
Size:	89.4 KB 
ID:	37881 If I answer yes I get no records added and this table added. All field names match and are alpha numeric. The excel file has less fields than the contact table.

  7. #7
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-18-2017, 07:05 PM
  2. Error on importing Excel file into MS Access.
    By Lou_Reed in forum Access
    Replies: 1
    Last Post: 09-01-2017, 02:15 PM
  3. Importing Excel and CSV into Access Error
    By baillie in forum Import/Export Data
    Replies: 2
    Last Post: 06-01-2017, 08:52 PM
  4. importing excel data to access via VBA
    By mazemi in forum Programming
    Replies: 4
    Last Post: 11-22-2016, 12:27 PM
  5. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums