Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trapping an Import Error (Access 2000)

    I'm using the TransferText method of the DoCmd object to import some CSV files. If there is a record that causes a violation of a relationship, a message is displayed asking of I want to continue. Is there any way to trap this event (apparently not an error)?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Trapping an Import Error (Access 2000)

    A violation of a relationship should be an error, not an event. If you want to *avoid* it, you could link the CSV files and do an append query from the linked table. That way, you can control what is appended to your table.
    Charlotte

Posting Permissions

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