none
ImportError table RRS feed

  • Question

  • Hi Everyone

    I was working with an Access 2013 database and was manually importing data from an Excel file into existing tables in the DB. As is often the case, there were a few records that errored out and could not be loaded.

    In other Access DBs, there records are populated in an ImportError table. However, no such table is created for these records.

    Is there a way to make sure this table is created? Is there some configuration that is preventing it from appearing? We want to take a look at the errors.

    Paul

    Tuesday, February 16, 2016 5:44 PM

Answers

  • Hi Paul,

    Based on my test in Access 2013, it creates the [table name]$_ImportErrors table if some records wrong. The table name likes [imported table name]$_ImportErrors, please make sure you check the correct table.

    You may try it in a new access 2013 database file and check the result.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, February 17, 2016 6:00 AM
    Moderator

All replies

  • You say you were 'manually importing data from an Excel file'

    Exactly what steps were you doing?


    Build a little, test a little

    Tuesday, February 16, 2016 6:08 PM
  • Hi Karl:External Data -> Import & Link -> Excel -> Append a copy of records to table....

    Paul

    Tuesday, February 16, 2016 6:14 PM
  • Hi Karl:External Data -> Import & Link -> Excel -> Append a copy of records to table....

    Post the SQL of your append query.

    Build a little, test a little

    Tuesday, February 16, 2016 9:52 PM
  • Hi Paul,

    Based on my test in Access 2013, it creates the [table name]$_ImportErrors table if some records wrong. The table name likes [imported table name]$_ImportErrors, please make sure you check the correct table.

    You may try it in a new access 2013 database file and check the result.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, February 17, 2016 6:00 AM
    Moderator