Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Validation on import

    Hi,

    I am importing xls files into Access and require certain validation checks on these fields. What I would like to do is import all of the data initially to be validated, have the invalid entires placed in a table and the valid in another. Access will notify me that invalid entries exist.

    Is there a way I can have the invalid rows (found from the validation) placed into another table immediately (allowing me to easily see which data is invalid and giving me the ability to manually fix)?



    Any help or suggestions on the topic is appreciated.

    Thanks!

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    You might want to import first to a staging table, and not directly into the "final" table. At that point, you can run your validation routines, and move the data into the final and the exception tables as needed. All of that can be mediated via VBA code. Without more info on what you need to do, it is hard for me to be more specific.

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

Similar Threads

  1. Data Validation - Please help
    By larry S in forum Access
    Replies: 0
    Last Post: 11-16-2008, 10:24 PM
  2. Validation Rule: Date
    By krymer in forum Access
    Replies: 0
    Last Post: 08-27-2008, 03:30 PM
  3. Validation on identical text question
    By edrahl in forum Database Design
    Replies: 1
    Last Post: 02-26-2008, 09:38 AM
  4. Validation Rule
    By mistaken_myst in forum Database Design
    Replies: 2
    Last Post: 10-29-2007, 02:08 PM
  5. Replies: 0
    Last Post: 09-25-2006, 07:14 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