Results 1 to 2 of 2

Thread: append query

  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: append query

    All, Using access 2003 frontend and sql server 2008 backend. I have an append query to insert 80000 from one table to an empty table. I get an error:

    "Microsoft Office Access set 0 field(s) to Null due to a type conversion
    failure, and didn't add 36000 record(s) to the table due to key violations, 0
    record(s) due to lock violations, and 0 record(s) due to validation rule
    violations."

    I know this error normally comes if there are dups in a field that doesnt allow.

    I checked for duplicates and there are none. I can't seem to find the problem. Any ideas?
    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My first guess would be that at least one of your early attempts was successful, so subsequent attempts after the successful attempt ought to fail.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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