Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Type conversion failure - which field? (2003)

    Just a quickie. I'm importing some data into Access am told that Access set 1 field to Null due to a type conversion failure. Is there any quick way of finding out which field Access was having problems with (as I have several fields which were null anyway)?

    Ta
    Waggers
    If at first you do succeed, you've probably missed something.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Type conversion failure - which field? (2003)

    See if Access has created a table with ImportErrors in the name, e.g. Table1 ImportErrors. This table provides information about the records and fields that caused problems.

  3. #3
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type conversion failure - which field? (2003)

    Thanks. No such table unfortunately. It's possible I turned off an option somewhere for creating error tables but I can't seem to find any such option anywhere obvious...
    Waggers
    If at first you do succeed, you've probably missed something.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Type conversion failure - which field? (2003)

    I don't think there is an option to turn that off.

    What happens if you lonk to the external table? If you don't get the same error message, you could compare the imported table to the linked table, for example using the method from <post:=641,181>post 641,181</post:>.

Posting Permissions

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