Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    35

    Question Unanswered: viewing the import error table

    I am importing numerous excel spreadsheets into Access 2000. Some of the data does not import because of key validation errors. In the help files they talk about the import error table which gives information on which records did not import; however, I am unable to find this table. Is there a way to view it or make a macro which would give me this information?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Try importing just ONE excel file at a time.

    Access creates two seperate tables that are viewable just like any other table.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Isn't that the Paste Errors table????
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Jun 2004
    Posts
    35

    error import table

    I don't think I used the correct phrases in my original post. I am importing 1 excel spreadsheet one at a time - I just have a bunch that need to be done so it will be an extremely long and tedious undertaking to compare the spreadsheet against the db as I have been doing.

    Everyone keeps saying that this import error table will show up in the same menu as my other tables. WRONG. Nothing changes. I am using a database that someone else created, could they have turned that feature off or made it hidden or something?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •