Results 1 to 2 of 2
  1. #1
    OneToLearn is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    8

    How To Get Alert Not All DATA were imported From Excel

    Hello everyone,



    I need a little help, maybe lots of help. In my little data base I have a button on a form, the button function is to import data from an excel spread sheet into a table. I use TransferSpreadsheet to import the data. I have had a few times that all the data(all the rows) were NOT imported into my access table due to mismatch description or others reasons. Is there a way I can set to alert me that the data were not imported and possibly which row(as a table). Could you please show me how this could be done?
    Thank you.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Doesn't Access create an "Errors" table when something goes wrong? Can you recreate the issue?

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

Similar Threads

  1. Replies: 3
    Last Post: 06-14-2013, 03:08 PM
  2. Replies: 1
    Last Post: 03-01-2013, 11:02 AM
  3. Excel rows sorted when imported to Access
    By gwn in forum Import/Export Data
    Replies: 1
    Last Post: 06-15-2011, 08:34 AM
  4. Automated Data Collection - Alert Required
    By MarkHenderson in forum Access
    Replies: 1
    Last Post: 11-25-2010, 06:21 AM
  5. Linking Access Table with already imported External Data (Excel)
    By izzarshah in forum Import/Export Data
    Replies: 1
    Last Post: 07-29-2010, 09:40 AM

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